Bring in Data

  • Thread starter Thread starter Biker
  • Start date Start date
B

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?
 
Biker said:
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?
Click to expand...

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
 
Back
Top