limit dropdown contents in entry forms

[Edward]

I ‘m creating a database to keep records for people who attend different
classes , so I have a class table(date,ID,type,…) also people
table(ID,Name,LastName,…) and a third table which has a combined primary key
of Class+People and a few more data like attendance code. I have created
three forms to enter data in each table, so user should create people table,
then a class, and at the end enter data in class-people table which keeps
data for any number of people who attend a particular class. The problem I
have in class-people table when I use the form to enter data class ID the
dropdown shows all the class ID( actually ID is hidden and I represent them
by date) even those classes that belong to the past date, I want to find a
way that in class-people form when I click on class ID dropdown it show only
future classes from class table not the past ones. Any suggestions?

 

[Arvin Meyer [MVP]]

You should build a query, the criteria of which will limit the data to just
the classes that you want. Then use the ID and description as the RowSource
for that combo box. The RowSource can either be a saved query, or the SQL
statement from that query, or a SQL statement referring to that query.