Unanswered: Form with reporting from two different forms
Please look at my form. I need the FCC Member form to print certain data on the heading of the New Entry form report. I also need to limit the number of entries it prints. I know about query but can not do that because it is two different form. I need this because we will be adding on to it every month. If anyone has a better idea I am all ears. Thank you.
* Get rid of the lookups in the table design.
* Modify your tables to conform to good database design fundamentals.
* Don't put spaces in Fieldnames. Access might allow it, but in all honesty, it shouldn't. Same for table names.
* Relate your tables.
* New Entry is not a good name for a table... where are the old entries? I would have named that table "Call" personally.
Study out relationships and table design and then study out queries and the answer should become clear.