creating search field in Ms Access !

[wanye]

hi all, i need help on e codes of creating a search field using a txtbox. (Coz i always encountered a prob on the setfocus whenever i click on the cmdbtn... )

May i noe wads the most standard way of creating such a search field, such that there r check fields function for empty,true & false entries..? n return e correct values from e db... (i got data type mismatch error on this) i need help on tis urgently. Thx..

[Mhtml]

Well, you just need to draw your form and create a query. Then just check the check boxes when the search button is pressed and execute the right query.

I'd do most of that by a module myself but it would be up to you.

Is this what you meant?

[wanye]

nt really, i mean by using a txtbox, it shld work like a wildcard... i need some examples of codes on creating tis kind of search field coz i am quite new to this...

[Spookster]

Your best bet is to probably ask here

http://www.access-programmers.co.uk/forums/

That's where I always go for Access help.

[scroots]

i have some code where you click the open wuery thing in access and it asks for a parameter in a prompt box.

I will dig it out at college and post it.

scroots