Hello all, I may need some assistance.
Working with an Access file, and it's designed as a navigation tabbed forms with subforms.
A user fills out a form and it's supposed to save the filled out form as a PDF, and for the most part it works. If the form is opened and filled out, it works as intended. But when going to the form with the tabbed navigation, it saves a file proper named as per the code, but it's saving a blank PDF with only the form header.
Here is the code when somebody clicks on the "SUBMIT" button. When the submit button is clicked, it's supposed to save the record, save the filled out form as a PDF, then have a msg box pop up confirming it has been saved and submitted and then goes to a "main window".
But it seems like it's loading a blank form before saving it as a PDF. As stated before, if opening the form seperately it works as intended though.
Private Sub CB_submit_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OutputTo acOutputForm, "Cath", _
acFormatPDF, "FILE LOCATION AND NAME".pdf"
MsgBox ("SAVED & SUBMITTED")
DoCmd.BrowseTo acBrowseToForm, "Code Calls", "MainForm1.NavigationSubForm"
End Sub