Combo box value is the same for every record...

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

Hi
Very basic... When I select one value from my combo box,
every record thereafter will have that same value. Going
nuts here, how to fix??
Thanks
Jane
 
Jane said:
Hi
Very basic... When I select one value from my combo box,
every record thereafter will have that same value. Going
nuts here, how to fix??
Click to expand...

Sounds like you forgot to bind the Combo to a field in your table.
 
-----Original Message-----


Sounds like you forgot to bind the Combo to a field in your table.
Click to expand...
Hi, Thanks for your reply. It is bound to a query, any
other suggestions?
Jane
 
Jane said:
Hi, Thanks for your reply. It is bound to a query, any
other suggestions?
Jane
Click to expand...

A ComboBox has a RowSource and a ControlSource. The RowSource determines what you
see in the list when you drop it down. The ControlSource is the field in the form's
RecordSet that the Combo is bound to. What do you have entered as a ControlSource?
 
The control source is "location" from the art inventory
table, and the row source is from a query, "location
query".
Sorry I'm really an amateur
 
Jane said:
The control source is "location" from the art inventory
table, and the row source is from a query, "location
query".
Sorry I'm really an amateur
Click to expand...

Ok, but is the form bound to the art inventory table? If it is, then I see no
reason for the Combo not to reflect the data that is in the table.
 
Back
Top