By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,315 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,315 IT Pros & Developers. It's quick & easy.

form detail will not print

P: 78
I am using a microsoft access 2002 (10.6771.6845) SP3 program and recently linked new table to one I have been using a long time, with a one (new table) to many (old table) relationship, which worked fine when I created 22 forms linked to the original table and form.

However, I wanted to have the pirmary key numbers posted in both tables at the same time. So, I opened the original table's query, linked the two tables in it, and dragged the new table's ID number into the query.
Because an ID is required, I went into the old table and changed the "not required" to "required."

When I re-opened the original form, instead of getting the 1500 records usually found, I got only 22, which corresponded to the number previously entered in the new table.

I deleted the "required" condition I had put into the original table's ID, I deleted the new table's ID from the original table's query, and I deleted the link I had created between the original and the new tables.


Instead of getting the 1500-plus records I used to have, I now have over 34,000, basically 15 copies or so of each original form. When I filter to work with a form, it reduces to one form which accepts all data just fine. None of the other forms I have developed based on the same table show this duplication, and the underlying table has only the original data, so everything else except this one form is fine.

The other problem is that to print this form yields only the heading, not the detail.

I tried database compact and repair, with no results.
Jul 8 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,287
If you delete the link in the query, you create a default JOIN with a line for each record from one table paired with each record from the other table. If both your tables have the same structures, you can create a UNION of both tables, which is what you want.

As for the printing, check the properties of the detail section, and make sure Display When is set to Always?
Jul 8 '09 #2

P: 78
Thanks for helping clear up the no-print problem, ChipR. As for the multiplicity of records, I'm going to try re-establish the link between the tables, and if that doesn't work, find out about doing a union.
Jul 10 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.