combo box

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

Guest

I have a table that includes a company name and address. If a user enters a
number associated with a company already in the table into a form's combo
box, I want the other data to fill in on the form, like the street address,
city, state and so on. If the user enters a number not associated with a
company already in the table, I want the user to be able to continue to enter
the rest of the data in order to update the table. Any suggestions?
 
You could use the event On Not in List to jump from your main form first to
a yes/no box which asks you want to add a new company, and then on to
another form which permits the user to add another company. When they have
finished adding, they save and exit, and the focus returns to the original
combo box which is automatically refreshed to show the new entry on the
list.

Linda
 
Back
Top