Combo box to populate fields in form

  • Thread starter Thread starter sw
  • Start date Start date
S

sw

I have a form that contains Product ID (primary key) then
Product Name, Product Price, Number in stock.

I want to be able to pick the Product ID from a drop down
list and have this automatically refresh the other fields
with the correct record information.

I have changed the Product ID field to a combo box but
when I click on the drop down the list is blank and I do
not see any Product ID's

How can I see all Product ID's in the drop down list and
how can I get this to automatically populate the rest of
the form?

Any help would be appreciated
 
You need to set the row source of the combobox to a list of unique product
IDs. Example:

Row Source: [Products].[ProductID]

Hope this helps,
- Glen
 
Back
Top