Sorry, am fairly new to access, but not databases,

i have a query nextmembernumber which returns one and only one
integer. I want to associate this query with a new button on a form,
so that (pseudo code):

if the new button is clicked then
if the membernumber form field is null then
execute nextmembernumber query and place the result in the
membernumber form field
end if
end if

how do i do it?

Thanks in anticipation

Replace generic names with real names:

Private Sub CommandButtonName_Click()
If IsNull(Me.MemberNumber.Value) = True Then _
Me.MemberNumber.Value = DLookup("FieldNameInQuery", _
"NextMemberNumber")
End Sub

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Broons Bane" <(E-Mail Removed)> wrote in message
news:31eff8ee-8071-4842-bcec-(E-Mail Removed)...
> Sorry, am fairly new to access, but not databases,
>
> i have a query nextmembernumber which returns one and only one
> integer. I want to associate this query with a new button on a form,
> so that (pseudo code):
>
> if the new button is clicked then
> if the membernumber form field is null then
> execute nextmembernumber query and place the result in the
> membernumber form field
> end if
> end if
>
> how do i do it?
>
> Thanks in anticipation

On Sat, 18 Apr 2009 06:40:34 -0700 (PDT), Broons Bane
<(E-Mail Removed)> wrote:

private sub myNewButton_Click()
if isnull(Me.myMembernumber)
Me.myMembernumber = DLookup("myQueryField", "nextmembernumber")
end if
end sub
(replace myObjectNames with yours)

Personally I would make that an Autonumber, so Access automatically
provides the next number. Your technique is appropriate if the number
is not just a meaningless number but a very specific one.

-Tom.
Microsoft Access MVP


>Sorry, am fairly new to access, but not databases,
>
>i have a query nextmembernumber which returns one and only one
>integer. I want to associate this query with a new button on a form,
>so that (pseudo code):
>
> if the new button is clicked then
> if the membernumber form field is null then
> execute nextmembernumber query and place the result in the
>membernumber form field
> end if
> end if
>
>how do i do it?
>
>Thanks in anticipation

On Apr 18, 5:01*pm, Tom van Stiphout <tom7744.no.s...@cox.net> wrote:
> On Sat, 18 Apr 2009 06:40:34 -0700 (PDT), Broons Bane
>
> <newsgrou...@yahoo.com> wrote:
>
> private sub myNewButton_Click()
> if isnull(Me.myMembernumber)
> * Me.myMembernumber = DLookup("myQueryField", "nextmembernumber")
> end if
> end sub
> (replace myObjectNames with yours)
>
> Personally I would make that an Autonumber, so Access automatically
> provides the next number. Your technique is appropriate if the number
> is not just a meaningless number but a very specific one.
>
> -Tom.
> Microsoft Access MVP
>
> >Sorry, am fairly new to access, but not databases,
>
> >i have a query nextmembernumber which returns one and only one
> >integer. I want to associate this query with a new button on a form,
> >so that (pseudo code):
>
> > if the new button is clicked then
> > * *if the membernumber form field is null then
> > * * * *execute nextmembernumber query and place the result in the
> >membernumber form field
> > * *end if
> > end if
>
> >how do i do it?
>
> >Thanks in anticipation

Thank you Tom, much appreciated.