reference a control on a form

[Frank]

I have a form with a tab control. The tab control has two
pages, with a list box on page2. How do i reference the
list box from another form so I can requery it?

I tried this but it didn't work:

Dim ctl as control

set ctl = Forms!Form1!tabMyTab!Page2!lstMyList
ctl.requery

 

[Allen Browne]

The tab control and its pages are not part of the reference. Just use:
set ctl = Forms!Form1!lstMyList