Search and update Form with a SQL Server Backend

[KLerma]

All,

I just upsized my from access to SQL Server and I am having some issues with a form.

Let me describe the form. The form has a couple of unbound text boxes and a submit button. The submit button runs some vb code that builds a sql statement based on what was in each unbound text box. It then displays the result set in a subform. Then I am able to change the data in the subform and it will update the table.

Now that I have performed this upsize, I am unable to update the results. How can I enable the result set to be updateable?

I have checked the "data entry, enabled, and locked" properties. They are correctly set.

Thanks in advance,

Klerma