query as source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that I would like to display with a query as a source. When
I do this the query works great but the user cannot change the data in the
subform. Is it possible to use a query and alter the data? If so what might
I have set wrong that is not allowing me to change the data.
 
Hi Jason,

It *is* possible to use a query as the Recordsource for a form. In your case
the query is probably a read-only query. This could be caused by a number of
factors:

- Group By Clause in the query (for summary or aggregate functions)
- Crosstab query
- Union Query

There are also many other possibile factors. Check the following for more
ideas on what might be causing your query to be read only.

Online help - in Answer wizard type the following:
"When can I update data from a query?" - open the article by the same name.

ACC2000: How to Edit Records in Related Tables in a Microsoft Access
Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;304474
 
Back
Top