Recordset not updateable

[jgelpi16]

I have a simple continuous form that has a combo box where the user can select three different options. This form is based upon a table where the only criteria is the UserID in the table match the UserID on the form. I keep getting the "This recordset is not updateable" error when I try to select an option from the combo box. What can I do to get around this?

[weekend00]

because you set the control souce of the combo box to a field of the data source of you form while the data source of the form is not updatable(maybe a query).

when you change the selection of the combo box, access try to update the "control source" field. if it's not updatable, it raise an error.

[jgelpi16]

Not quite sure I follow....

The data source for the form is a query, not the table itself. Is the only way to get around this to directly relate the form to the table? If that is the case I would have to filter the form in VBA as opposed to in SQL. Was trying to avoid that but I will if it is necessary.

[jgelpi16]

I went ahead and just did the filter in VBA instead of the SQL. Thanks for the help.