code to update field on another form

[tizwaz]

can anyone tell me what is the correct syntax to do the following. I want to put the code on the after update event of a field on formA to set the value of a field on formB where the ID numbers match.

 

[KenReay]

Hi

Assuming both forms are loaded, and both contain the IdNo then

If Me.IdNo = Forms!formB!IdNo Then
Forms!FormB!IdNo = Me.IdNo
End if

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[djjesp]

Put your code on the afterupdate event of the form
Jesp

 

[KenReay]

Hi

No he said:

"I want to put the code on the after update event of a field on formA "

and that should be OK

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[tizwaz]

thanks Ken