Edit data in a combo box on a form tied to a query

[JulieMarie]

I have a form in which users enter contract information. This form has combo boxes that display the status of the contract they are entering. They also enter in old data as it is discovered. This information updates the contract and vendor tables. I run a query on the contract and vendor tables that opens a form to display the current contract. I added a combo box for the status field. It is pulling up the status in which the user entered on the data entry form. That's great! However, when they want to terminate the contract or change its status in any way can they do that from here? Can you have a combo box with the row source the same as the original data entry form but still have it pull the current information unless the user wants to change it?

[Dal Jeanis]

By definition, if a combo box on your form is bound to a field on your table (say, status), then updating the combo box on the form will update that field on the table, for the current record. It sounds like that's the behavior you want, so you're good to go.

There DO exist queries that are NOT updateable, generally because the creator used a UNION, or left out a field that Access would need to find the right record that needs updated. If you find that you have this problem, then come back and tell us about it and we'll help you fix the issue.