I watched your video on How to Create a Large, Custom-Sized Checkbox in Microsoft Access Forms & Reports and when it came to putting the VBA code to an event, I do not have "Before Update" and "After Update" Events in my selection list. I am running Microsoft Office Professional Plus 2016 so I would have thought that these would be available. Am I missing something in my settings? Live long and prosper, John
Kevin Robertson
@Reply 8 months ago
Did you use a Label instead of a Text Box?
John RobertsOP
@Reply
8 months ago
I used the Toggle button as shown in the video.
I have come up with a work around for the time being, putting the VBA code into the "On Got Focus" event for the form.
This works, but I am curious as to why I don't have the "Before Update" and "After Update" events on my Toggle Button Property Sheet?
Donald Blackwell
@Reply 8 months ago
Hi John,
I suspect the reason that you're unable to access Before Update and After Update is that you're using the toggle button on a report.
Because reports aren't intended for updating data, just reporting on the data you have, the update methods such as "Before Update", "After Update", "On Change", "Dirty", etc., aren't available.
If you are on a form, then I would double check to make sure you didn't grab a command button instead.
Don
John RobertsOP
@Reply
8 months ago
Thanks Donald, you have nailed it on the head.
I was trying to use it on a report.
Richard was correct, you guys are the best.
John
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
