Problem referring to a control in another form

[igillesp]

Hi!

I thought that this would be simple.

I created a form (frmProgress) to act as progress informer when a series of longwinded queries run - the idea that the user would be a bit more informed than they would by staring at a progress bar.

It has several labels (e.g. lblLB2, lblMol, lblUpdate) which describe the progress points and next to each is a tick (e.g. lblLB2Tick, lblMolTick, lblUpdateTick).

The idea was that the first form (frmUpdate) would open frmProgress as a popup and the ticks would become visible as the queries progressed.

I thought that this would be a matter of including...

Forms![frmProgress]![lblLB2Tick].Visible = True

...between the lines of code executing the queries but I get...

Runtime error '2450' MS Access can't find the form 'frmProgress' referred to in a macro expression of Visual Basic code.

I've tried variations on the syntax and tried using frmProgress as a subform but to no avail.

I imagine its really simple but for the life of me I'm stumped.

Please help!

Thanks,

Iain

 

[boblarson]

Where did you put this "code?" Did you put it in the VBA window or in the form PROPERTIES dialog? It needs to go in the code window. See here for more about that:

http://www.btabdevelopment.com/main/LinkClick.aspx?link=56&tabid=55&mid=385