How do you allow a query to accept data to input. Pretty sure this works
sometimes and not others. So if I have a form that looks to a query for
information and I want it to update the table...well can I do that. Thinking
it might have to be a single table query? Thanks!!!!
> How do you allow a query to accept data to input. Pretty sure this works
> sometimes and not others. So if I have a form that looks to a query for
> information and I want it to update the table...well can I do that. Thinking
> it might have to be a single table query? Thanks!!!!
Some queries are not updateable.
See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail