you go to 'create query in design view' and then select which table you want to use. drag which fields you want into the table. in the criteria row you paste in: LIKE "*" & (Enter any character to search by:) & "*" whatever is in the brackets will show up when the persons decides to query. save and name the query.
when you want the form to open up after the person has typed in what they are looking for you have to: go to 'create form using wizard' and then click the drop down window and select the query you need to make it show up and select which fields will show up. then select the style, format, name it and click finish. now when you click the form it will open the query.
No comments:
Post a Comment