stardustvega
Member
- Local time
- Yesterday, 19:51
- Joined
- Feb 4, 2022
- Messages
- 36
I have a continuous form filtered to a query, so that it only shows entries where the inactive box is NOT checked. When I click a button, I want the current record to update to change the value of the inactive field to 'true'.
The query which is the record source for this particular form looks like this:
My simplified VBA for troubleshooting looks like this:
When I run this I get "Object Required".
Okay, I thought maybe I need to be more explicit. I added an "Inactive" field to my form to see what the control source was and then tried this:
This time I get "Microsoft Access can't find the field |1 referred to in your expression."
I suspect my problem has to do with the fact that the fact that my form is based on a query, but I'm not sure how to fix it.
The query which is the record source for this particular form looks like this:
Code:
SELECT [Junction Events-Vendors].*, [Junction Events-Vendors].Inactive
FROM [Junction Events-Vendors]
WHERE ((([Junction Events-Vendors].Inactive)=False));
My simplified VBA for troubleshooting looks like this:
Code:
MsgBox (Inactive.Value)
When I run this I get "Object Required".
Okay, I thought maybe I need to be more explicit. I added an "Inactive" field to my form to see what the control source was and then tried this:
Code:
MsgBox ([Junction Events-Vendors].Inactive.Value)
This time I get "Microsoft Access can't find the field |1 referred to in your expression."
I suspect my problem has to do with the fact that the fact that my form is based on a query, but I'm not sure how to fix it.