Possible to requery or refresh a form without saving data?

Mitleid242
Mitleid242 used Ask the Experts™
on
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...
Comment
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