Search Box in Access Form
I have a Contacts database with families from church and friends & family. I am trying to create a text search box in a form that has 2 subforms on it. The subforms are linked with the FamilyID. I want to create a Search Box on the top of the form that will sort of mimic the Search box on the bottom of the form. Can anyone help with an idea?
thank you so much for just taking the time
Marian
1 Attachment(s)
Search Box In Access Form
Thank you so much for responding! I am using Office 2019 (but Access is default to 2016). I would like to be able to search LastName and then FirstName (they are Short Text). Currently I am using that little search box on the bottom of the form but it is a pain. I have tried the Combo but I just get a list of everyone and I still have to hunt for them. I have been trying to create a "search as you type" kind of text box but I really am not that great at the programming yet. I am just learning VBA. As for the database, the Main form is the Family (which consists of the parents), the 1st subform is the Children Subform. It is linked by the FamilyID and each child has their own ChildID.
I look forward to your reply
Marian