Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Possible to requery or refresh a form without saving data?

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...
0
Mitleid242
Asked:
Mitleid242
1 Solution
 
wellileinCommented:
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.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now