How does Requery cmd change from form to subform?

[GaborH]

I have a text box with Dlookup on a continuous subfrom. The text box updates by click event, specifically a macro with Select Object and Requery command.

While the subform is used alone, the textbox updates properly. However, when used with the main form, I get a Failed Action error. Specifically, the Select Object command cannot find the subform.

Can someone spare a hint on this issue?
All hints are highly appreciated!
Thank you,
GaborH

 

[Darrylles]

Hi,

Look at how to refer to a subform object from Access help

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk