Hi All,

I'm trying to print a record from a subform with the following code, where "Custsub" is the name of the subform control and "CustFName" is the name of the first field in the record:


Private Sub CommandPrint_Click()
DoCmd.GoToControl "Custsub"
DoCmd.GoToControl "CustFName"
DoCmd.RunCommand acCmdSelectRecord
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
End Sub


What this button is supposed to do when clicked is select the entire record in the subform and then print it. What it does instead is select the main form and print it. If I rem out the PrintOut part, it does actually select the entire record. Why won't it print it, though? I just need it to print the selected record only.

Any/all help appreciated.

Thanks!