a better way to update?

[Anne]

I have table with membertype (number) and a dues required table
If the data in membertype is a 1, I want it to update my dues required
field which is Yes/No as a yes.--

what is the proper way to do this
I have been using an update query but is there a better way
thanks

[PC Datasheet]

If you are updating all the records in your table, using an update query is
correct. If you are doing it for one record on a form, put the following code in
the AfterUpdate event of MemberType:

If Me!MemberType = 1 Then
Me!DuesRequired = True
Else
Me!DuesRequired = False
End If

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Anne" <am******@ns.sympatico.ca> wrote in message
news:ur*********************@ursa-nb00s0.nbnet.nb.ca...

I have table with membertype (number) and a dues required table
If the data in membertype is a 1, I want it to update my dues required
field which is Yes/No as a yes.--

what is the proper way to do this
I have been using an update query but is there a better way
thanks

[Trevor Best]

PC Datasheet wrote:

If Me!MemberType = 1 Then
Me!DuesRequired = True
Else
Me!DuesRequired = False
End If

Or in one line:

Me!DuesRequired = (Me!MemberType = 1)

;-)

But the first way allows for more in the way of expansion, e.g.

If Me!MemberType = 1 Then
Me!DuesRequired = True
Msgbox "Don't forget these are required"
Call SendSomeMail()
Call RingSomeBell()
Call BlowAWhistle()
Else
Me!DuesRequired = False
End If

Pretty difficult in one line :-)

--
Error reading sig - A)bort R)etry I)nfluence with large hammer