Eric the Viking
Registered User.
- Local time
- Today, 03:58
- Joined
- Sep 20, 2012
- Messages
- 70
Dear All
I have a main data entry form for my fishing club that is based on a parameter query using two parameters.
I have another continuous form that allows me to see at a glance who has paid up and who hasn't.
I would like to have a button on the continuous form that uses the two parameters to allow me to open the main data entry form based on the parameter query.
I have tried using various iterations with DoCmd and OpenArgs but I am clearly doing something wrong as I still get asked to enter the parameters rather than this happening through the VBA.
This is what I have tried in various formats:
Private Sub Command21_Click()
DoCmd.OpenForm "frmEnterMembersDebitsAndReceipts", OpenArgs:=Me.[Surname] & FirstName
End Sub
Hope someone can help.
Cheers
I have a main data entry form for my fishing club that is based on a parameter query using two parameters.
I have another continuous form that allows me to see at a glance who has paid up and who hasn't.
I would like to have a button on the continuous form that uses the two parameters to allow me to open the main data entry form based on the parameter query.
I have tried using various iterations with DoCmd and OpenArgs but I am clearly doing something wrong as I still get asked to enter the parameters rather than this happening through the VBA.
This is what I have tried in various formats:
Private Sub Command21_Click()
DoCmd.OpenForm "frmEnterMembersDebitsAndReceipts", OpenArgs:=Me.[Surname] & FirstName
End Sub
Hope someone can help.
Cheers