linking one field in one form to another field in another form

[mrunknown]

ok i know this may be one of the easiet things to do in microsoft access but i was wondering if anyone can tell me how to link one field in say a customer form to another field in say a supplier form

what i want to do is to allow one value from one field to match the value of another field when ever that value has changed

e.g. if text1.value in customer form = 5 then text2.value in supplier form should equal 5
if text1.value in customer form = 7 then text2.value in supplier form should equal 7

thanks for any help

 

[butthead]

I am still learning the basics also so my input
may or probably is not the best.

try the on change event for the field in question

you will probably have to do a bit of vba coding

[form first].[text0] = [form second].[text12]

or maybe something similiar. may be this will give you
something to ponder.


good luck

I am sure the experts will set you straight in no time.