automating data entry field

Q

qaman

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.
 
R

Rick B

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.
 
Top