I'm trying to create mt first database and quickly finding I'm out of my depth so thanks in advance

i have a table of competitors and a table of sections (for a competition) the sections have min and max age and the competitors have an age
I'm trying to build a form to input entry's i have two combo boxes to select competitors so want a third combo box to only display relevant sections that the competitors can enter

i have been playing with creations a query to only show the available sections but cant get this right

please help

Adam

---

Reply from Alex Hedley:

You can create a Parameter Query and pass the values from your chosen combos to this Query to return the list for the third combo.

- Microsoft Access Parameter Query
- Get a Value from an Open Form Field