Linked Combo boxes with number list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form where a combo box lets you choose how many charts were reviewed (5,10, or input your own numer).

Below this are 2 other combo boxes that have you choose how many of the chart were up to date for 2 different parameters (Med List, Problem List).

Is there a way to set up the linked combo boxes so that the listed numbers is always less than or equal to the number they chose in the first combo box?

Right now I just have the 2 lower boxes linked to a table that consists of the numbers 1 to 10.

Thanks for any help.
 
The newbie figured out 1 way to do it..please let me know if this is a bad/too complex way.

The # Charts Reviewed combo box has an after update statement to requery for the Med List UTD como box AND the Prob List UTD Combo box...

The query is a query of a table with numbers 1 to 10 with subquery Criteria being

<=[Forms]![MedProb review]![Number of Chars Reviewed] *pulls the current value from the active form, first combo box and the query will list all values less than or equal to the value.

Ahhh..where did that 3 hours go...
 
Back
Top