Trigger requery of form by clicking in subform?

[Max Moor]

Hi All,
I've used the OnClick Event with listboxes to have a form requery
when its underlying query is based on a value in the listbox.
Now, I want to do the same thing, but using a subform, rather than a
listbox. I see that I can do it if I have a separate OnClick event for the
subform's detail and every conrol on it. That seems like it's harder than
it should be. Is there another, easier way?

- Max

 

[Dirk Goldgar]

Hi All,
I've used the OnClick Event with listboxes to have a form requery
when its underlying query is based on a value in the listbox.
Now, I want to do the same thing, but using a subform, rather
than a listbox. I see that I can do it if I have a separate OnClick
event for the subform's detail and every conrol on it. That seems
like it's harder than it should be. Is there another, easier way?

I suppose you might place a transparent command button, sized to cover
the entire detail section of the subform, on top of the detail section
and its controls. Then you could use the Click event of that button.