Requery sub-form from popup

G

Guest

Hi all

I strange question I know but….I have a main form with a number of tabs
controls
FrmMain
TabOne - TabTwo - TabThree - Etc

The main has a button that opens a popup with a number of controls. (one
combo and a number text boxes) - Combo1 - Txt1 -Txt2 - Etc

Is it possible to requery TabOne afterUpdate of Combo1 (on the popup) - so
neither the main form or the tabs have focus

TabOne and the popup are based on the same table – but different queries as
TabOne will not allow updates (for wierd reasons) and the popup will.

Not sure if it directly possible but has anyone got or used a work-around.
How to reference TabOne from the popup would be a great help.
Have tried Forms![frmMain]![TabOne] but this won't unless the popup loses
the focus which I don't to happen (again for wierd reasons)

Many thanks
 
G

Guest

It's OK - I got it
Just a matter of saving the popup - closeing - requery mainform
Something like Save +
DoCmd.Close acForm, "mainform"
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top