PDA

View Full Version : Filter pulldown by gender



TVining
05-24-2017, 11:26 AM
I have a pulldown on my form which pulls from [Flights].[flight] that I want to limit based on the value of (same form) [participants].[gender].

If Gender=F, I want only C,E,P,R to be offered and if Gender=M, I want A,B,D,F,G,P,R to be offered.

Any help with that?

TVining
05-24-2017, 11:31 AM
UPDATE: I added "Gender" to the source table, M or F or B (for both)

OBP
05-25-2017, 01:07 AM
Can you clarify that a "Pulldown" is "Combo Box" and that the C,E,P,R is literally the choice of C or E or P or R and A,B,D,F,G,P,R is A or B or D or F or G or P or R?