Refresh Form on open.

[Phred]

Access 2007, Compiled, not split, single user, Normalized, intermediate skill level.

Form 1: See LPV.JPG LPV=Lowest Price Vendor. When you click the button a series of queries run that take thousands of prices and process them so that the lowest price vendor is displayed for each food item. This writes the final data to Tbl_LPVCurrent. This works fine.



Form 2: See DailyInventory.JPG Daily Inventory Reads information from Tbl_LPV Current and displays it on the screen. This works fine. It is based on a select query that reads the LPVCurrent table.



If the end user clicks the button on the LPV screen, creates a new LPV, then clicks on the Daily Inventory Tab the screen it shows the items #Deleted see DailyInventoryDeleted.Jpg.





I understand why it is doing this. If I click the f5 button to refresh, the screen refreshes and the correct data pops up. I understand this.

I am trying to make the Daily Inventory screen refresh automatically when it is opened. I have tried code running from the LPV screen and have tried code in lots of different Events in the Daily Inventory screen such as:
GotFocus me.refresh or me.requery, etc.

OnCurrent
OnLoad
OnEntry
OnOpen

Private Sub Form_GotFocus()
Me![CmbPickItem].SetFocus
Me.Requery
End Sub

None work.

But when I hit f5 it refreshes perfectly.
Where should this be located?

Thanks

[June7]

Daily Inventory is a subform?

The button is on LPV subform?

I always give subform container control name different from the object it holds, like: ctrInventory

Try code in the button Click event, like:

Forms!MenuPro.ctrInventory.Requery

or the tab control page Click event, like:

Me.ctrInventory.Requery

[Phred]

Thanks Again June7. I am slowly getting it.

I will close this out.

Phred