Assuming by that you mean one certificate per report (a report with only one record). If not, it might be best if you just uploaded a copy of your db. See how to attach files button at the top of this page. I can make a control invisible or not with this if you want to try it first:
form button code
Code:
Private Sub Command6_Click()
DoCmd.OpenReport "EmployeeInfo", acViewPreview, , , , Me.Combo2
End Sub
report load
Code:
Private Sub Report_Load()
If Not Me.OpenArgs = "" Then
Me.[First Name].Visible = False
Me.[Last Name].Visible = False
If Me.OpenArgs = "Dan" Then Me.[First Name].Visible = Not Me.[Last Name].Visible
If Me.OpenArgs = "Mary" Then Me.[Last Name].Visible = Not Me.[First Name].Visible
End If
End Sub
That is in a db I play with that I didn't create, so don't follow those bad habits (combobox name stinks; fields have spaces in them, etc.)
Please consider not using reply with quote button for new posts so that everything from the prior post isn't repeated.