automating data entry field

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

Guest

Hello, I designed a database with a data entry form which includes a supplier
field and a supplier ID field. Is there a way without writing code to enter
an ID number in the ID field and have the appropriate supplier entered
automatically in the supplier field? Thanks.
 
Why do you want to do so without code? Typically, you would do this using
simple AfterUpdate code. The sample Northwinds database that ships with
Access has a great example of this in the Form_Orders where it completes
address fields after a Customer Id is selected when creating a new order...

Take a look at that and copy the functionality you want.
 
Back
Top