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

[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

 

[Rick Brandt]

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??

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

 

[Jane]

-----Original Message-----


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

Hi, Thanks for your reply. It is bound to a query, any
other suggestions?
Jane

 

[Rick Brandt]

Hi, Thanks for your reply. It is bound to a query, any
other suggestions?
Jane

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?

 

[Jane]

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

 

[Rick Brandt]

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

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.