Print Specific Report from data on form

JSDART!!

Registered User.
Local time
Yesterday, 22:23
Joined
Mar 12, 2004
Messages
31
I have a command button to print the note from the open record.
I am using the code
stDocName = "Reproduce progress note"
DoCmd.OpenReport stDocName, acPreview, , "[PNID]=" & Me![Text2]
this works
however in another location in the database I have a multi-tabed form that on the last tabed page has the same type of command button and code and this is not working.
This last tab-ed page has a subform that is set to data entry for a new Progress note.
I think the problem is that when you enter the data it is to recognized as a record until you complete the record and so the report will not open to that record.
I do not know how to force the record in with out going to the next blank record and then the comand button dosent work.
any suggestions would be appreciated
thanks
J
 
an additional comand button did the trick

I had to add a command button to save the datas of the subform.
the user need to print the report in 2 steps
click on the save record and then on the print note.
wanted it to be a 1 step but 2 works.
Thanks
 

Users who are viewing this thread

Back
Top Bottom