Combo box selection for queries

[Paul]

I have a form which is used to plan exercise sessions for clients. It is made
up of combo boxes with choices of types of workouts that have been complied
in other forms. I need to a: get the combo boxes to choose the correct
queries based on the choice of each box ie in mondays box I may choose cardio
prog 1 I need it to get the cardio prog1 info from the table using a query
that only relates to that specific client and allow it to be printed in a
report. This needs to be done for all 7 days of the week and generated into 1
report called sessionplanner. The client then can take this away and have all
relevant training plans for each day based on the choices made. I think Ive
included my b: in the above.

Regards
Paul

 

[[MVP] S.Clark]

suppose cbo1 and cbo2, where cbo2 is dependent of cbo1

In the cbo1.AfterUpdate event ,set the rowsource of cbo2, based on the cbo1
value.

e.g.

with cbo1
if not isnull(.value) then
cbo2.rowsource = "SELECT * from [Tablename] Where [Somefield] = " &
..value
end if
end with


--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting