Form with unrelated fields

[Guest]

I want to be able to print reports with several variables pre-selected to
either includee or not include (e.g. certain cites, client types, etc...).
Each of the variables is in a look-up tbl & qry (e.g. LU_VARIABLE) with an
"include" field (yes/no). My idea is to have one form open prior to any
report that will set the variable as either yes/no.

I went to create the form but it says the fields are unrelated (presumably
because each is in a seperate tables). I assume I could create a form for
each variable then imbed it as a subform. Is there an easier way to create a
form that includes all of the variables without using many subforms?

 

[Allen Browne]

How about an unbound list box where the user can select multiple cities at
once? That way you don't have to redesign the form (adding more check boxes)
every time a new city gets added.

If that sounds okay, see:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html