Refresh Form

[tpcervelo]

I have 3 tabbed forms (Home, CustomerOrders and GreenSheet). Home has command buttons to open the other forms, run an update macro or quit the App. A button on CustomerOrders will add a record to GreenSheet. I have a docmd.runsql which inserts the reocrd. I want the record to be visible if the user switches to the GreenSheet form. It only appears if I close and reopen the form manually. I tried a [Forms]![GreenSheet].Requery after the insert but that didn't work.
Any help is much appreciated.

[RuralGuy]

What is the source of the values displayed on the GreenSheet tab?

[tpcervelo]

The source of form Green Sheet is table GreenSheet which I insert the record from form Customer Orders (table Customer Orders).

[RuralGuy]

So your tabbed MainForm has a SubForm on the GreenSheet tab, correct?

[tpcervelo]

RuralGuy,
I did not set any forms up as sub forms. There are 3 separate forms...Home, Customer Orders and Green Sheet. I open Home on startup and the user opens either of the other 2 from command buttons on Home. Customer Orders hooked to table Customers to insert records into table Greensheet (hooked to Form Green Sheet) and Green Sheet form to delete records from table Greensheet. The records are being inserted because I can manually close and reopen form Green Sheet and they appear. I tried to attach a requery on form Green Sheet's OnFocus but that didn't work either.
Hope this makes the description of my app and problem cmore clear.
thanks...

[RuralGuy]

You can test to see if the other form is open using the Forms collection and Requery the form if it is. Does that help?

[tpcervelo]

Solved it...I had the wrong form name on my Requery after the RunSql insert. Appears to be working now.
Thank you very much for your help...I will mark as solved.

[RuralGuy]

Excellent! Thanks for posting back with your success.