I am sorry if this is a basic question, but this is the first database that I have tackled from scratch... I have a form that I would like to display only records that are Under Review, with the only other option being complete. I based a form on a query, which excluded certain records from the table. But when the form is open, the user is unable to edit the record? I was unable to figure a way to solve this.. Any help would be appreciated. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Form based on query - remain editable
- Thread starter ddotson
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Take a look at the underlying query -- most likley that is your problem. If the query cannot be edited, neither can any forms or queries based on it.
Generally, you cannot edit these kinds of query:
Totals
Crosstab
Any query where the primary keys for the relevant tables are not included in the query grid.
Check tp see that this is not the case: if it is, change the query until it is editable and save it. You should be OK after that
Denis
Generally, you cannot edit these kinds of query:
Totals
Crosstab
Any query where the primary keys for the relevant tables are not included in the query grid.
Check tp see that this is not the case: if it is, change the query until it is editable and save it. You should be OK after that
Denis
Upvote
0
