I am trying to edit a table through a text box on a form instead of directly in the table, but cannot edit the data.

1. The form is set up with its own query as a recordsource to a table.
2. Control source for the text box on the form bound to a field in the table recordsource at the control source.

3. Locked property is set to no, Allow Edits, Data Entry,Deletions, Additions are all set to yes.

It seems like I have everything set up logically to do this, but I am stumped because I cannot edit anything on the form for some reason.

Any helped on what I am doing wrong would be appreciated.

Stumped,
Coby.

More info:

Is this based on a query? If so, is the query updatable? Try updating the query in the query designer and see if you can do that first.

Is the data on a remote DBMS, like SQL Server? Or local or remote Access tables, etc.



mmcdonal

Yes, this is based on a query which, after a couple tests, is not updatable either. The table is a remote access table.

You would need to base the form on an updateable recordsource then. I am not sure what will work for you, not having seen the structure and without knowing your needs.

You may have to move to an update process that happens behind the form with code if there is no other way to display the data you need.

mmcdonal