Requery a subform on a tab control

[RedSkies]

Hi all,

It's been a while since I've done any in depth work with Access so I've gotten a little rusty. Can anyone help me out with a syntax question? Here's the situation:

Parent form name: frmProjectOverview
Tab control name: tabProjects
Subform name: subfrmFocusArea
Listbox on subform name: lstFocusAreaDesc

Question: I'm running code from another form to update the table on which the lstFocusArea field is based, and I want the subform to display the updated data when the form is closed. What is the syntax for requerying the listbox on the subform, within the tab control located on the parent form?

I tried a couple of variations, for example:
Forms!frmProjectOverview!tabProjects.pages(1)!subformFocusArea.Requery.

However, nothing I've tried seems to work. Any advice would be appreciated!

Thanks

 

[Mile-O]

The fact that it's on a tab is irrelevant.

If I remember rightly,

Forms!frmProjectOverview!Forms!subformFocusArea.Requery

 

[RedSkies]

No joy I'm afraid

That doesn't seem to work either.
Thanks anyway though. I'll continue with the trial and error approach!

 

[KevinM]

Forms!frmProjectOverview!subformFocusArea!
lstFocusAreaDesc.Requery