Combobox Help

[jlgray0127]

I have a form, with a combo box.
The combobox is on one table. The values for the combobox are on another table. I want to either manually change the value of the combobox on my form, or use an update query, which looks at multiple other tables, and update my combobox for me, base on it meeting the criteria I load in the query.
I have the query written, and have everything set up to do, just what I want to happen, however I'm getting an error, stating I have to use a query that is updateable.

I've not come across this before, and am not sure why the combobox will not allow me to change it's value with the query. I have to be able to update the combobox manually and with the query. The combobox is the status of an order.
The database was originally designed, VERY manually, and now I'm trying to auto mate it more. So, where before, the order status was all based on what the user looked up, and determined his status was, now we have more data available, which allows us to look at different criteria with queries, to determine what the status is. The manual portion is done, only if we pick or ship the order. The query will ignore the status, if it's in a picked or shipped state.

That made it real confusing for a definition of my problem.

Basically stated, I need to be able to run and update query, and change the value of a combobox based on the results of this query. Please help! I don't have a ton of time to continue redoing this database, and this is the quickest option I see for now, without adding alot of code, tables and forms to do what I hope is possible with the update query!


Thank you!

[ItsMe]

Bind your form to an updatable query. Use one of the form's fields for your combo's Control Source.

[ranman256]

The combo values will always be up to date based on the values in the table/query.
Your question is confusing.
You want to select a value in the combo, then do what?
update the combo to a different value in the combo?

[June7]

Setting combobox RowSource does not change value in record. If you want to programmatically set the status value, why a combobox? Use a textbox to display calculated value. Saving calculated data (data dependent on data) is usually not advisable. Calculate the status when needed.

[orange]

Can you restate what exactly you are trying to accomplish?