Parameter Query

D

David Amdur

I'd like to use a parameter query to enter data in records, but when I run
the select parameter query, Access won't let me enter data. How can I unlock
the query to allow me update various fields?
 
V

Van T. Dinh

Your Query is probably not updateable and the cause is _not_ the Parameter.

Check Access Help topic "Updatable Queries" which explain briefly on when
Queries are updateable and when they are not. The Help Topic also shows a
few techniques on converting an unupdateable Query to become updateable.
 
F

fredg

I'd like to use a parameter query to enter data in records, but when I run
the select parameter query, Access won't let me enter data. How can I unlock
the query to allow me update various fields?
Click to expand...

See Microsoft KnowledgeBase article 328828:
"INFO: Troubleshooting Errors That May Occur When You Update Data in
Queries and in Forms"

Also in Access Help, type
'When can I update data from a query?'
in the Help Search box.
 
Top