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
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