J
Jo
I have a database with multiple tables and I want to use a form to query one
field which is common on all tables. When I open this form it asks me to
enter the criteria 8 times, as I have 8 tables. I have done my query by form
by using a macro which opens the 7 queries then displays the results on a
series of subforms in the form itself. I know this is a really akward way of
doing it but the tables are huge and have many varying fields and the account
no. is the only common field.
Any help would be appreciated, as I'm going insane!!
field which is common on all tables. When I open this form it asks me to
enter the criteria 8 times, as I have 8 tables. I have done my query by form
by using a macro which opens the 7 queries then displays the results on a
series of subforms in the form itself. I know this is a really akward way of
doing it but the tables are huge and have many varying fields and the account
no. is the only common field.
Any help would be appreciated, as I'm going insane!!