Refresh

[DBFIN]

Test findings showed that when I open a form the data does not update. I added a refresh action after the openform action. If I want to open three forms via the macro, do I need three refresh actions, one after each openform action, or simply a single refresh action that would apply to all three forms.

Scenario 1:OpenForm1, Refresh, OpenForm2 Refresh, OpenForm3, Refresh
Scenario 2:OpenForm1, OpenForm2, OpenForm3, Refresh

 

[pr2-eugin]

Test findings showed that when I open a form the data does not update.

What? When a Form is opened, you will be presented with data, why would you need a Refresh in the first place?

Scenario 1:OpenForm1, Refresh, OpenForm2 Refresh, OpenForm3, Refresh
Scenario 2:OpenForm1, OpenForm2, OpenForm3, Refresh

Both scenarios IMO, do not even need to be considered ! What is that you wish to do?

 

[DBFIN]

The form datasource is a query that reads from a table. The query criteria is an "ID" field that uniquely identifies each record. When the form is opened, it incorrectly opens the ID from the prior transaction instead of the current transaction. I found that when I added both refresh and requery, it fixed the issue. Maybe the refresh is not needed, but it seems the requery is. Do I need one or three requeries. If you have an alternative, I'd welcome your suggestions. I appreciate all your help !!

 

[pr2-eugin]

I have a different scenario, I have an three Unbound ListBoxes in the Form, these are nothing but Notes corresponding to each client, (for some management purposes, I had to go with this, normally I would use SubForm). This scenario called for Requery of the listbox, based on the ClientID, and yes if there is three Listboxes, you need three Requeries.

But if they are forms I am unsure ! Unless they are forms inside a form? then they might just need to be linked with the parent and child ID.

 

[DBFIN]

I think you answer is exactly what I was looking for. While the scenario is slightly different, I think there is certainly a parallel in what we are both trying to accomplish. I will need to add the three requeries for the forms as you also needed multiple requeries for each list box.

Thank you so much for your input !! I am always so impressed with the expertise and insight that is offered in this MS Access World Forum. You guys are the best !!!

 

[pr2-eugin]

You are most welcome ! Good Luck !