How can I replicate the dropdown list select event?

  • Thread starter Thread starter Norman Fritag
  • Start date Start date
N

Norman Fritag

Hi there,

How can I replicate the dropdown list select event, without having to select
an item from the dropdown list box?

Eg: normally the dropdown listbox would not have more than 5 different date
values eg: 05/3/2004 to 10/03/2004.

When the user selects one of the dates,(which are part of the dropdown list
range) on the subform(tab), I would like to trigger (requery) 2 other
subforms (sitting under 2 separate tabs) that relate to the date selected.

At the moment the user has to select a date from the drop down list box.
With the afterupdate event I requery the sub forms to get the result. It
works ok and I like to take it a step further.

or is there a totally different way of doing it?

Kind regards

Norman
 
Norman Fritag said:
Hi there,

How can I replicate the dropdown list select event, without having to select
an item from the dropdown list box?

Eg: normally the dropdown listbox would not have more than 5 different date
values eg: 05/3/2004 to 10/03/2004.

When the user selects one of the dates,(which are part of the dropdown list
range) on the subform(tab), I would like to trigger (requery) 2 other
subforms (sitting under 2 separate tabs) that relate to the date selected.

At the moment the user has to select a date from the drop down list box.
With the afterupdate event I requery the sub forms to get the result. It
works ok and I like to take it a step further.

or is there a totally different way of doing it?
Click to expand...

Me.ComboBoxName = #(someDate)#
Call ComboBoxName_AfterUpdate

But... If the user doesn't select the date how does your program code know which
one to use?
 
Rick,
Thanks

I only want that function active when the usere selects that date.

Regards

Norman
 
Norman Fritag said:
Rick,
Thanks

I only want that function active when the usere selects that date.
Click to expand...

You lost me. If the user is selecting the date from the list then you can
use AfterUpdate as you stated you were in your first post. What exactly do
you want to do differently?
 
Back
Top