Refresh Another Form On Form Close

[Jamz]

Hi guys,

I have a macro that inserts a new entry into the database, then closes the window.

Now this is done by a macro, but what I would like is when the form closes, the main windows gets a refresh, but I cannot figure out how to get the main page to refresh without using VBA - is this possible?

 

[vbaInet]

I don't use macros but isn't there a form's Requery action or similar?

If there isn't then you should be able to use one of the RunCommand constants. You will need to set focus to the form first.

 

[ted.martin]

Try using this code or at least put itin a separate Function and RunCode from the Macro

If currentproject.allforms("YourFormName").isloaded = true then
[Forms].[YourFormName].requery
end if

 

[vbaInet]

Try using this code or at least put itin a separate Function and RunCode from the Macro

If currentproject.allforms("YourFormName").isloaded = true then
[Forms].[YourFormName].requery
end if

It's a macro question Ted

Now this is done by a macro, but what I would like is when the form closes, the main windows gets a refresh, but I cannot figure out how to get the main page to refresh without using VBA - is this possible?

 

[ted.martin]

True, but we both know code is the way to go hence my suggestion to call this bit of code from a macro runcode function. The sooner coding is learned, the quicker this user will advance.

T

 

[vbaInet]

Quite right. But perhaps he or she already knows VBA but wants to know the macro equivalent.