Saving to Table

[Zerdan]

I have a form displaying results from a query that links multiple tables which I only have read privileges. I want to have 2 fields where the user can enter some additional information and save to a new table.



I know I need a unique ID for each of the entry, an ID to link back to the other tables, and 2 columns to store the new data. I can get it to all display properly if I go into the table and enter the information manually, but I cannot get the fields to be editable.

One is a text field and when I click in there (after having entered info manually into the table so it is already showing) trying to type more or deleting just results in no action. The other is a combo box that results in it showing the options but not allowing me to click on them to select. Under properties they are set to Enabled: Yes, Locked: No.

Any ideas? Thanks!

Edit: The form is set to Allow Edits: Yes

[NTC]

the query that serves as the record source for the form is probably not updateable - - is my initial guess.

for the ability to 'enter some additional information and save to a new table' : you should consider using a subform.

hope this helps.

[Zerdan]

Very much so. I got it working as soon as I put a subform in. Thanks!