Hello All..
I have a table called "INVOICE" that contains a buch of records. I have a report that contains a few text boxes asociated to the fields in the INVOICE table.
Within the report, I need to print 3 SPECIFIC records.
I have a form that is NOT associated to the INVOICE table but instead assoicated to another table. The form contains a button on it. The button's OnClick Event uses the DoCmd OpenReport function to call the report and the specific records I want in the report utilzing the 'where condition'.. below is the code of that command specifically:
DoCmd.OpenReport "INVOICE REPORT", acViewPreview, , Event_Number = 55 And Event_Number 13 And Event_Number = 32
Regardless if the report is previewed on the screen out outputted directly to the printer (via acViewNormal), the report is empty. I thought that it was due to my many where conditions and attempted to only put 1 event number and still it did not display any records in my report.
I then assumed that maybe it was a display issue with my computer. so on my report's OnFormat Event, I put some code to test my theory and the debug kicked in basically telling me that the report really doe s not contain any records..
So the million dollar question.. What is wrong with my DoCmd OpenReport statement that is causing the report not to display any records in it? Do I need to do something to my report to achieve the results I'm looking for?