Form with unrelated fields

I

Ian

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?
 
A

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
 
Top