Edit Table through a Form
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.