Perform a query After Update

[Trauton]

Hi,

I am creating a form the will have these controls: CustomerCode,
CustomerName and CustomerAddress. When a new record is created we will type
in CustomerCode ( which will be stored in tblA), after I tab away from the
CustomerCode Control, I want the Customer Name and CustomerAddress fields the
form to be populated with the information from tblB using the information
from the CustomerCode control that I just typed. tblB contains the
CustomerCode, CustomerName and CustomerAddress fields. I just want to display
them in this form if a match is found.

I think I need to do this with an After Update event in the CustomerCode
field, but I would appreciate helping figuring out how.

Thank you!!

Trauton

 

[Steve Schapel]

Trauton,

The following article gives examples of several approaches that can be
taken to this...
http://accesstips.datamanagementsolutions.biz/lookup.htm

 

[Ofer]

Check this link, about preventing duplicates

http://www.databasedev.co.uk/duplicates.html

======================================
There is one option that you can use on how to populate values to different
fields

http://www.mvps.org/access/forms/frm0009.htm
======================================

 

[Trauton]

Thank you Ofer. I appreciated the duplicate links also since I had been
looking for a way to let the users know that they are entering a dupplicate
record (before they have typed the whole information), as it currently is
with my form now.

 

[Trauton]

Thank you Steve! Very clear examples covering several ways to do it. I have
bookmarked it.