How do I look up a record using a combo box in Access

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

Guest

I have a normal Access database table that I would like to display on a form.
I created the form based on this table but used a combo box to display the
'CustomerId', which is hidden, and 'Customer Name' fields. On running the
form and selecting a customer name the form does not update with a new
record. The form works fine with the navigation controls at the bottom of
the form.
 
By doing this You don't select the customer name, You are changing it, and
assigning it to another data in Your table(which is currently displayed)! If
You want to do things which you mentioned You have to think about
master-detail form. In master form You should put a Combo box control which
RowSource property is set to Customer table. And when You insert
subform(which is also bounded to Customer table) by using Form wizard,
Access will ask You which field will be used for connecting two forms. You
have to use CustomerID from master form, and CustomerID from detail form.
When You select the customer name or its ID, data in subform will change. It
looks complicated but it's not.
Vojislav Depalov
 
Back
Top