Report print loop

[orange]

Just post code or whatever here in the forum.

[xjps]

Ok. If I run the report from the side menu (red) it works and prints fine. If I run it from the nav form (green), that is where the loop on print occurs. I am not sure where the code for the nav form is located because when I click the show visual basic button, the functions are all blank. Thanks.

[ssanfu]

PMFJI,

Please note that it is not "Best Practices" to have spaces in object names. (Objects include field, table, query, form and report names.)
It would be better if your field names were

SELECT 
Pilots.[FirstName], 
Pilots.[LastName], 
Pilots.[BaseMonth], 
Pilots.[CertificateNumber],
Event.[EventName], 
Event.[EventDescription], 
Event.[ValidDuration], 
Event.[DateCompleted], 
Event.[DateExpires], 
Event.[EventType], 
Event.[Cert_Num]

FROM Pilots INNER JOIN Event ON Pilots.[CertificateNumber] = Event.[Cert_Num];

Note the lack of spaces in names....

You have not provided any info about what you are trying to accomplish, so I have some questions.

What constitutes a "CertificateNumber"?
Can the "CertificateNumber" for a pilot ever change?
Does a pilot only have 1 "CertificateNumber"?
What are events?
What is the primary key (PK) field in the two tables?

I have concerns that you have table design issues. I don't think you should be linking the tables using "CertificateNumber".

Maybe you would make a copy of the dB, delete all but 5 pilot records, change any sensitive info and post the dB. Change the names to something like Fred Flintstone, Barney Rubble, etc.
Compress (zip) and post.

[xjps]

Thanks for the reply. I figured it out. The database is sound (other than the object names) I am familiar with SQL. My issue was with Access itself. I was trying to use the navigator as a type of home page / report launcher type thing and it was messing up the reports. I deleted it and just used a custom form to launch the reports and input data. It all works as expected now.

[ssanfu]

Happy you solved the problem

Good luck with your project.......

[orange]

Glad you have it resolved and thanks for posting your solution.