View Full Version : Search form


alguzman
03-26-2002, 10:43 AM
I want to have a seperate search form using unbound text boxes. I'm currently using Combo boxes as my search and the following code.

docmd.openform "Members",,,"[MemberID]= "&Me![combo2].column(0).

I would perfer to use txtboxes so that if a user enters something like MICRO the database will open the memberform with all the records that start with MICRO.

My problem is that I'm not very good at vb coding. I need some help if someone can get me on the right track here would be great.

Fizzio
03-27-2002, 01:15 AM
I use a query by form method. Base the form you want to filter on a query. Build your search form, or include an unbound search box on your main form. In the query you have based the form on, set the criteria of the field you want to filter on to =[Forms]![NameofSearchForm]![NameofTextBox] for an exact match, or
Like "*" & [Forms]etc & "*" to search for the in any part of the field.

HTH