Greetings,
I have three tables. I joined them using a select query.
I created a form with the query as the source.
When I open the form, I see the values from the tables.
But when I click on a field to update the data, nothing happens. I need to update the field and write back to the table.
Do I need an update query instead that will update either of the three tables?
Is there a form setting to allow updates or do I need module code to set on focus, on load or on click for that field or the entire form?
I even created another blank form, linked in the three tables and joined them, not using the select query. But this does not allow updates either.
Do I need to have a subform for each table. If so, then how do I join the three together to make one recordset?
This is probably an easy fix. Thanks for your help!
I have three tables. I joined them using a select query.
I created a form with the query as the source.
When I open the form, I see the values from the tables.
But when I click on a field to update the data, nothing happens. I need to update the field and write back to the table.
Do I need an update query instead that will update either of the three tables?
Is there a form setting to allow updates or do I need module code to set on focus, on load or on click for that field or the entire form?
I even created another blank form, linked in the three tables and joined them, not using the select query. But this does not allow updates either.
Do I need to have a subform for each table. If so, then how do I join the three together to make one recordset?
This is probably an easy fix. Thanks for your help!
