static report form needed?

[can]

I have lots of data that needs to get reported. One problem is i have -

In my form if I change the source of the data from one table to another, all the boxes (in the report) show errors and all the report comes up empty.

Is there any way to dynamically link these fields? The fields and locations need to be static, but the queries may generate different data. but, its all the same type and such all the time.

The application is a list of customers by zipcode. One day we will need to print this report for a certain zip code or other criteria. and print the report. The next day it will be other zip code or critera.

The form wizard is quite horrible in terms of formatting the page. it always is waay to big.

Martin

 

[mresann]

A form can only have one recordsource. So you can't bind two tables to the same form.

However, you can (and you should) create a query that obtains the data from multiple tables and creates the records you need to display on the form. Once you save the query, you can then use that as the recordsource of the table.

If you aren't sure how to create queries, then your tables are probably not normalized, so the form wizard would probably not be at all effective.