automatic refresh rescords - Access TechHelp


	Back to Access TechHelp Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

automatic refresh rescords

Stephen Hamer

3 years ago

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` After Update

	Stephen Hamer OP @Reply 3 years ago
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 Hamer OP @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

	Kevin Robertson @Reply 3 years ago
Check these out: Refresh v Requery Requery in Place Requery Subform

	Stephen Hamer OP @Reply 3 years ago
Thanks again.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access TechHelp.

Next Unseen

New Feature: Comment Live View