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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup column 4
Pop up form - field not updated 2
default value from another table 1
Form with subform and record insert problems 2
automatically create new record in lookup table if data does not e 9
filter query on combo box in a continuous subform 0
Order entry form using data from a second table 5
ComboBox results on form show as a number in report 1

Back
Top