I am using a nav form to navigate between my data entry forms. when the form in question is opened under the nav form the button produces reports with no data. if I open the form independently sometimes it works and sometimes not. I opened independently and not in data entry mode it works great. Coding is as follows:
Private Sub Command23_Click()
DoCmd.OpenReport "Produced Water Ticket Data", acViewReport, , "[Ticket Number]=" & Me.[Ticket Number]
DoCmd.OpenReport "Produced Water Ticket Data SWD", acViewReport, , "[Ticket Number]=" & Me.[Ticket Number]
There are two different reports listed that are supposed to draw from the same form. What am I missing?