>>>The "Print Report" button has the following code in the click event: PreRepID = Names.name_id
>>> Report Form Intake.frx For Names.name_id = PreRepID To Printer
>>>
>>>The "Preview Report" click event is similar:
>>> PreRepID = Names.name_id
>>> Report Form Intake.frx For Names.name_id = PreRepID Preview
>>>
>>>Any suggestions?
>>>TIA
>>>--Lincoln
>>
>>You may make your code 100% reliable by selecting this one record to a cursor and print from this cursor.
>
>
>How do I do that?
Select * From ... Into Cursor tmp Where name_id=...
Report Form ...
Select tmp
Use
Edward Pikman
Independent Consultant