Hi there,
Still a newbie in Access.
I'm trying to write a DoCmd.OpenForm and the Enter Paramter Value box is coming up. My Table name is Code Review and the column is Reviewers.
Please it's driving me nuts.
Private Sub Command13_Click()
DoCmd.Close acForm, "Menu"
DoCmd.OpenForm "Peer Review Report", acNormal, , "[Code Review].Reviewers Is Not Null", acFormReadOnly, acWindowNormal, strUser
End Sub
Still a newbie in Access.
I'm trying to write a DoCmd.OpenForm and the Enter Paramter Value box is coming up. My Table name is Code Review and the column is Reviewers.
Please it's driving me nuts.
Private Sub Command13_Click()
DoCmd.Close acForm, "Menu"
DoCmd.OpenForm "Peer Review Report", acNormal, , "[Code Review].Reviewers Is Not Null", acFormReadOnly, acWindowNormal, strUser
End Sub