Use Combo box to limit records when subform is based on query?

  • Thread starter Thread starter Steve C
  • Start date Start date
S

Steve C

A little background:

I have a database which manages hot air balloon flights
at a hot air balloon festival. There are six "flight
times" at which flights occur - FRI PM, SAT AM, SAT PM,
SUN AM, and SUN PM.

I have a form which displays two subforms, one
with "flights" which contain PilotName and FlightTime
among other fields. The contents of this "flights"
subform are the results of a query which finds flights
which have open seats on them.

The other subform displays passenger information, so that
passengers may be seated on flights listed as "open."

What I'm trying to do is limit the amount of records
shown in my subform (which is based on a query) by FLIGHT
TIME. For instance, when we sit down to use the database
Friday night, we only want FRI PM flights to show up in
the subform.

Can anyone offer me some possible ideas I could try?
Thanks a lot,

Steve C
 
There is an easy, no code way to do this provided your table doesn't contain more than a few thousand rows. It might be too slow for a large table but you can try it. Access is amazingly fast.
1. Open the form in form view
2. From the Records menu choose Filter/Filter by form - this changes your form so that you can filter by any field on it. It adds combo boxes for all fields so you can just choose FRI PM or SUN AM and whatever other criteria you want.
 
Back
Top