Subform requery

[BrettM]

When a subform (which is attached to a query) is programatically requeried, what events are actually triggered on that subform?

I am wanting to update the control accessability on record change of a subform (dependant on control content). I have the routine to update the info, just need the correct event to call it from. Tried most of the listed ones with no joy.

Any suggestions?

Brett

 

[rainman89]

by programatically, what do you mean? you need it to requery every so often?

 

[BrettM]

Hi Ray,

The subform uses a query filter to look up data based on a combobox. Change the combobox and the subform changes. Some of the controls on the subform are initially switched off, dependant on what data is actually available. I needed to look at the current record and automatically set how the controls are to be displayed.

New morning... recharged brain.

Problem solved. Was not thinking straight and had the routine I wanted to use set to private instead of public.

Thanks for your response though.