Using a check box to call a form

[mrdirectorsir]

I'm writing a database for our dance club to track membership. The table is fine, and I use a form to list members who need to be renewed or have information updated. The problem is, from the "Renew Member" form, I have a check box to Edit Member Information. I want this to be able to call the member's form who I'm renewing, but it only opens a blank form. How do I get this to open the Update From Renew form?

[June7]

Is the Renew Member form bound? Is its DataEntry property set to No?

Something like this should work:

DoCmd.OpenForm "Renew Member", , , "MemberID=" & Me.MemberID