querry's and subforms

  • Thread starter Thread starter Ulrik Beersaerts
  • Start date Start date
U

Ulrik Beersaerts

Hello,

I'm new and not very used to work with access (and newsgroups)
I've the following problem :

I've a form with two subforms. Those subforms show me the results of two
querry's.

In my form , there are two drop down boxes and when I change the input in
the dropdown boxes , the querry's must give me another result (but they
don't start yet)
I've made a link between my querry's and the drop down boxes , but I don't
know how i've to let the querry's run?
(I've already tried with an "after update" but without result)

I'm sure that there is someone smarter than me , can you help me please ?

Ulrik
(e-mail address removed)
 
I've made a link between my querry's and the drop down boxes , but I don't
know how i've to let the querry's run?
(I've already tried with an "after update" but without result)

I'm sure that there is someone smarter than me , can you help me please ?
Click to expand...

Go to the properties in the combo box, select the OnChange event, then open
the code builder.
Within the subroutine add the code something like:
Me![field name of the subform].Form.Requery

Marc
 
Back
Top