Bring in Data

[Biker]

I have a form that I would like to display a set of
questions depending on what type of school record it is.
For example: I have a Flight school up and based on that I
want a series of questions only dealing with Flight
schools to appear on this form. Right now I have 4
different types of schools and 4 tables filled with
questions based on the type of school. How can I do this?

 

[Marshall Barton]

I have a form that I would like to display a set of
questions depending on what type of school record it is.
For example: I have a Flight school up and based on that I
want a series of questions only dealing with Flight
schools to appear on this form. Right now I have 4
different types of schools and 4 tables filled with
questions based on the type of school. How can I do this?

Why do you have a separate table for each school? do they
have fundamentally different data? If you had one table
with an additional field to indicate which school the
question is related to, then the answer to you question
would be to just filter the form on the school field.

But, if you're going to continue separate tables, then
you'll have to reset the form's RecordSource property:

strSQL = "SELECT * " _
& "FROM " & thisschoolstable " _
& "ORDER BY somefield"
Forms!theform.RecordSource = strSQL