I cannot find the lesson on refreshing tables and queries automatically using the build event field. If you could point me in the right direction, that would be helpful.
When I make changes to the yes/no fields in the tables they are not updating so I have to press the refresh button unless I go off the record.
Dan Jackson
@Reply 3 years ago
Hi Stephen. You want to go to the After_Update event for each checkbox and simply put
Me.Requery
Thank you, that's great. This is covered in one of the Access database courses, isn't it? Do you remember which ones?
Dan Jackson
@Reply 3 years ago
Its mentioned in a ton of videos. Can't think of any specifically other than the after update but essentially, whenever Rick needs to reload after making a change, he uses this method. It probably in the top 3 of all lines of codes he uses
Stephen HamerOP
@Reply 3 years ago
OK. I'll find it as I refresh my memory of the content.
Thanks again.
Dan Jackson
@Reply 3 years ago
You can see what i mean by searching for requery in the sites search box. Loades of videos
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
Access TechHelp.
