Records Not Updatable

[Guest]

I'll try to keep this short.

I have a form with a ComboBox that is bound to a column in the form's source
table. The ComboBox source is an employee table and the number of columns
set to 2 (name and empno). It is bound to the second column, empno. I was
requested to add a "Not Used" choice to the drop-down list. I change the
source to a union query to something like listed below:

Select name, empno form emp_table union select "(Not Used)" as name, "99999"
as empno from emp_table

The query works and lists the "(Not Used) in the ComboBox drop-down, but now
the form/table is not updatable.

Any advice?

Thank you!

 

[Ken Snell \(MVP\)]

The RowSource query used for a combo box will not have any effect on the
updatability of a form via the form's RecordSource. If the form is now
saying that it's not updatable, then some type of change has been done to
the form's RecordSource query that now makes the query nonupdatable.