Trigger requery of form by clicking in subform?

  • Thread starter Thread starter Max Moor
  • Start date Start date
M

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
 
Max Moor said:
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?
Click to expand...

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.
 
Back
Top