Search forms

M

Megan

I have two linked forms created and they are working great, but now I would
like to add a form that user can enter different search criteria into and
retrieve the filtered forms that match their criteria. I have a dialog box
created to allow users to enter their search criteria, but can not get it to
function. Everytime I run the query it comes up with a blank record, and the
search command button on my dialog box does absolutely nothing...please help
if you can...thanks so much in advance!
 
R

Rick Brandt

Megan said:
I have two linked forms created and they are working great, but now I
would like to add a form that user can enter different search
criteria into and retrieve the filtered forms that match their
criteria. I have a dialog box created to allow users to enter their
search criteria, but can not get it to function. Everytime I run the
query it comes up with a blank record, and the search command button
on my dialog box does absolutely nothing...please help if you
can...thanks so much in advance!
Click to expand...

Post the SQL of your query and the code behind your button.
 
M

Megan

Okay I have solved the query poblem, now I am getting results, but I don't
know how to link it to my dialog box
 
R

Rick Brandt

Megan said:
Okay I have solved the query poblem, now I am getting results, but I
don't know how to link it to my dialog box
Click to expand...

What does "...link it to my dialog box" mean? If your query is using
controls on the Dialog Box for its Criteria then that is as linked as it
gets.
 
Top