I've got a table, TBLtennisbookings, which has the field MemberID. The MemberID has a combo box query so that it displays the FirstName and Surname from the table TBLmember.

I'm trying to do a SELECT search query so that it displays only the TBLtennisbooking records which are made by that member. It works at the moment, but only if I type in the MemberID number. I want it so that I can type in the name.

Is this done by DLookup or something? I'm not sure.