I have a MS Access database (see attached).
The frmClassEntry from is where I enter members who attend a workout class. When I enter the Member ID and hit enter the data below populates with the member’s name. If I don’t know the member’s ID number then I click on the Search Member button and the form frmSearchMember opens. Then I lookup the members name to find the Member ID number and then I switch back to the frmClassEntry to enter the Member ID.
How do I use the frmSearchMember to search for the member by using one any of the text boxes and clicking on the record and then it gets entered in to the frmClassEntry from.