How Can I populate a field only If certain conditions are met?

[Dave Mann]

I want to be able to get my last service date field to be updated when
a workorder is completed, how can i get this done if i require it to
look into the service history subform and confirm first that the equip
ID and the service code match the Equip ID and Service code in the
Equipment service list subform if they match then update the Last
Service done field with the date entered in the Date Delivered field in
the history subform?

otherwise if no service is done or its a new piece of kit then allow me
to enter my own date.

Hope this make sence.

I can send the dbase to anybody willing to help.
any queries contact me on bb*****@hotmail.com

Thanks Guys n' Gals

Oh! for all those guys out there i have had more responce from women so
come on dont let the side down!
Below is what i am tryping in the field i am trying to update.

=IIf([Forms]![Equipment Form]![Equipment History
Subform].[Form]![Service Code]=[Service Code] And [Forms]![Equipment
Form]![Equipment History
Subform].[Form]![EuipID]=[EuipID],[AllowUpdating],[Forms]![Equipment
Form]![Equipment History Subform].[Form]![Date Delivered])
Thanks
Rgds
Dave Mann

[pietlinden]

use a subroutine that does it for you? create a function that contains
all the stuff you need to verify that will return T/F and then if
fOKtoProceed=True, then call your subroutine that does all the
updating. Yes, I know it's probably overkill breaking it up like that,
but it's MUCH easier to debug that way. Get the function working, then
get the sub working and you're in business.
Or have you never programmed in VBA before?

[Dave Mann]

Hi Piet,

Thanks for the reply, i am not that good at Sub Routines. Can i send
you a copy of my Dbase for you to look at?

Rgds
Dave
pi********@hotmail.com wrote:

use a subroutine that does it for you? create a function that contains all the stuff you need to verify that will return T/F and then if
fOKtoProceed=True, then call your subroutine that does all the
updating. Yes, I know it's probably overkill breaking it up like that, but it's MUCH easier to debug that way. Get the function working, then get the sub working and you're in business.
Or have you never programmed in VBA before?