Parameter Query

[Guest]

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?

 

[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.

 

[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?

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.