Perform a query After Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thank you Steve! Very clear examples covering several ways to do it. I have
bookmarked it.
 
Back
Top