473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Refresh a Form

Dear reader,

I have a strange situation.

In a Form with a list box to search for a record in the form it self. The
field in the list box is also available in the form. On an other form I
have the same field after changing the field and closing the form with the
following code by the event on close:

Forms!FormNaneWithListBox.Refresh

Forms!FormNameWithListBox.Recalc

Only the field in the list box has the changed value and the value of the
field in the form it self remains the old one. Only after closing and
opening of the form with the list box al information on the form is changed.

In case close and open the Form is the only way to refresh the information
than a need a command to comeback on the same record as by closing the form.

Is there a command the refresh all information on the form.

Tanks fore any help.

Kind regards

Simon van Beek
Nov 13 '05 #1
2 2908
Not sure I follow you, but try using Requery instead of Refresh ... Refresh
simply requeries the underlying recorset, as it was created, including and
edits made by other users. Requery will rebuild the recordset and include
edited/new/deleted records. If you're trying to filter a form based on a
value in another form's listbox, then let us know the code you're using to
filter.


"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:42*********************@reader1.nntp.hccnet.n l...
Dear reader,

I have a strange situation.

In a Form with a list box to search for a record in the form it self. The
field in the list box is also available in the form. On an other form I
have the same field after changing the field and closing the form with the
following code by the event on close:

Forms!FormNaneWithListBox.Refresh

Forms!FormNameWithListBox.Recalc

Only the field in the list box has the changed value and the value of the
field in the form it self remains the old one. Only after closing and
opening of the form with the list box al information on the form is
changed.

In case close and open the Form is the only way to refresh the information
than a need a command to comeback on the same record as by closing the
form.

Is there a command the refresh all information on the form.

Tanks fore any help.

Kind regards

Simon van Beek

Nov 13 '05 #2
Forms!MyForm.Requery will refresh form data, but unbound controls will
not be reset, because they are not bound--i.e. not coming from the
underlying table or query.

Forms!MyForm.MyListBox.Value = Null

will clear a list box, and indeed Null will reset any control that
doesn't have a calculated (i.e. beginning with "=") control source.

But it's not clear to me whether you want to refresh data, or jump to a
record, or synchronize two forms, so that's all I can offer.

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: John Baker | last post by:
Hi: I have a Pop Up form that involves a main form and sub form. The sub form has the results of a query on the main form. I need to automatically perform exactly he same action that takes...
5
by: Andrew Chanter | last post by:
I have a situation where I am using an unbound dialog form to update data in an Access 2002 split back end / front end scenario. The data update is done via an ADO call (direct to the back end...
2
by: Peter Oliphant | last post by:
I now have graphics being drawn in the Paint event of my form (yeah, and it's very cool). Problem was that it only updated any changes to these graphics when Paint was called. So, I then made it...
10
by: tasmisr | last post by:
This is an old problem,, but I never had it so bad like this before,, the events are refiring when clicking the Browser refresh button. In the Submit button in my webform, I capture the server side...
6
by: scott | last post by:
I guess this is a simple one but I can't seem to get it to work. I want to refresh an open form "onClose" of another. I have a Close button on a form which has User Details on it. If I update...
2
by: Robert | last post by:
I am trying to give the user dynamic search capabilities to select almost any record in the database from criteria they select. Everything seems to work except when I open the display form to...
12
by: martin1 | last post by:
All, is there window form refresh property? I try to set up window form refresh per minute. Thanks
5
by: tshad | last post by:
I have an interface I am using to get access to some of the objects on my form: a textbox (Status) and my statusbar (StatusBar). In my class, which is actually in another class from my form I have...
5
by: BlackBox | last post by:
I have a Listbox1 in the main form and I can add listbox1 items in the parent form. But when I close the parent form Listbox1 in the main form does not get refresh. I need to re-open the app. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.