I have a form that opens to allow the user to enter a new record. Here is the onclick code of the command button on another form that opens the form:
DoCmd.OpenForm "frmAddVisit", acNormal, , "[MemberID] = " & Me.txtMemberID, acFormAdd, acWindowNormal
But on the form that opens for a new record entry I want to have a command button that makes the form appear as if the user has opened it for edit. In other words, show all previous records for that MemberID.
Is this possible?