Query Update Problem

[TheStriker]

Hello,

I am attempting to add a record to my tables through a form based on a QUERY. The form has combo boxes for the user to select description text from, however the tables only reference the ID of the description text. When the user selects the description without the ID, Access adds the record to the source table which I don't want to do.

Is there a way to display the description text in the combo boxes, but store the ID so the tables are REFERENCED and not updated. Let me know if you need more info...

Thanks in advance

 

[dcx693]

Sounds like you have two issues here:

1 - You don't want to alter the source table when someone picks out a description or an ID. You want to add a new record. It sounds like your control is a "bound" control (the controlsource property has the name of a field in your source table). Make it an unbound field (blank out the controlsource property).

2 - You need to add a column to your combo box so that the "bound" column is the ID column whereas the dislayed column is the description column. Use a query to be the source type of your combo box and add the proper fields. Set the column width of the ID field to be 0 and set it to be the bound column.