Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Possible to requery or refresh a form without saving data?

Posted on 2003-10-28
1
Medium Priority
?
362 Views
Last Modified: 2011-09-20
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
Comment
Question by:Mitleid242
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
wellilein earned 200 total points
ID: 9634900
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question