Possible to requery or refresh a form without saving data?

Mitleid242 used Ask the Experts™
I wanted to know if it would be possible to design my forms so that when options that determine what is visible/invisible are changed, I can just code all of the visible properties into the CURRENT attribute of the form. The problem with requerying though, is that it asks me to save my form because I have a save changes function built into the BEFORE_UPDATE. Does anyone have any recomendations on how I can requery, or maybe just refresh, my form without altering or saving any of the data currently entered? Thanks in advance...
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Is it MS Access? Portions of Access's forms (like Listboxes for example) can be requeried.
For example if you have a button on your form that adds a new location to a table containing those locations, you can requery the list that displays the locations. Command is ListBox1.Requery

If that is what you need, have a look at http://www.wellisolutions.de/experts-exchange/items.zip which contains a form just doing that. I coded it for another experts-exchange question and it would be fine if you could use it :-)

You can also set its visibility to false and when setting back to true perform a ListBox1.Requery on it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial