Record Refresh on Linked Forms - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Record Refresh on Linked Forms

Robert Sena

4 years ago

I am using a button to open up a subform to input data. I inserted a button in my subform to add new records which also automatically saves my record entry. I want to add to the macro of the button to also refresh the data on the main form Can it be done? If so how will I do it? The main form will refresh when I get out of my subform and hit the refresh button but it would be nice to allow the users to see what they are inputting without leaving the subform. Thanks in advance. I know VBA might be easier but I still have lots to learn.

	Adam Schwanz @Reply 4 years ago
If you just want the main form to refresh when you do something in the subform, you can just use an after update event on that button and do something like Forms!FormName.Refresh AfterUpdate

	Robert Sena OP @Reply 4 years ago
There is not an update event on the property sheet of the command button. Would I place the expression on "No Enter"?

	Adam Schwanz @Reply 4 years ago
Put it in the on click event of a button. At the bottom after you run your code.

	Robert Sena OP @Reply 4 years ago
Can I run it in a macro instead. I already created a macro to so some other stuff when I click on the button. I'm not very proficient in VBA. In the macro, there is a refresh option but that is for the form I'm already on. How would I reference my main form instead. I'm learning a lot but can get frustrating at times. Google only takes you so far.

Richard Rost @Reply

4 years ago

If you want to refresh the parent form from a button on the subform, it's literally one line of VBA code:

Me.Parent.Refresh

That's it. To do the same thing with a macro you have to mess around with GoToControl and a bunch of other steps. So make a button, pick the Code Builder, put that one line of code in the event, and there you go. Watch my Intro to VBA video if you need help. It's not that hard. VBA is sooooooooo much better than macros when you learn a little bit.

	Richard Rost @Reply 4 years ago
And yeah... Google only takes you so far... that's where we come in. Google will give you a million answers. We'll give you the RIGHT answer.

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

Next Unseen

New Feature: Comment Live View