Form based on query that is based on many queries

  • Thread starter Thread starter DMainland
  • Start date Start date
D

DMainland

I use a form that is based on a query for 'read only' purposes. The query on
which the form is based is itself based on multiple queries from multiple
tables. I would like to be able to edit the data presented on the form after
having used the filter by form operation to bring up a record. Is this
doable? I set the properties of the form to 'yes' to allow edit, add,
delete, etc. but am unable to change the data as presented after the filter
is applied. I hope I have been clear enough in explaining the situation.
Any help would be greatly appreciated.
 
I use a form that is based on a query for 'read only' purposes. The query on
which the form is based is itself based on multiple queries from multiple
tables. I would like to be able to edit the data presented on the form after
having used the filter by form operation to bring up a record. Is this
doable? I set the properties of the form to 'yes' to allow edit, add,
delete, etc. but am unable to change the data as presented after the filter
is applied. I hope I have been clear enough in explaining the situation.
Any help would be greatly appreciated.
Click to expand...

Multitable queries are not necessarily editable; queries based on multiple
other multitable queries are almost certainly NOT editable. You're bringing up
"a record" - I presume this record contains fields from multiple tables? do
you want all of the tables to be edited? Might it not be better to use a Form
(for the "one" side table) with Subforms (for the "many"), which will be
editable and will display the same information, probably in a more user
friendly fashion?
 
Back
Top