Connecting Tech Pros Worldwide Forums | Help | Site Map

Filter Selection with Code on Form

Corey
Guest
 
Posts: n/a
#1: Nov 13 '05
I have a form bound to a query with several thousand records in it. I
want to be able to have a combo box that lists 4 or 5 of the query
fields and an unbound textbox that i can supply data then have a
command button filter the records that match. I dont know where to
start with this, so i figured here is as good as any... I really
appreciate any help that is provided! -Corey


starace
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Filter Selection with Code on Form


You'll be building a dynamic query in vba.

how experienced are you in building your own functions and procedures?
I could start posting some code here but if you dont know what to do
with it whats the point.

I am willing to help you out, dynamic queries are my speciality.
<smirk>

When you respond give some more info about the structure of this form.

also i posted some code a couple of weeks ago about building dynamic
queries. search "dynamic queries" or just my username.

Closed Thread