using query results to populate a list or form

[chrisse_2]

Hi,

I need some help. I have created a form where there are 3 combo boxes
and a text box to search through records. Based on what the user fills
in, you then it a "go" button to run the query and obtain the search
results. This is all working correctly except for the fact that it
opens up the results in datasheet view.

What i want to happen is, when the user hits "go" to run the query, the
results are used to populate a list box on the same form.

Can anyone help me?

[PC Datasheet]

Set the listbox's row source property to the query and put the following
code in the "go" button's click event:
Me!NameOfListBox.Requery

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<ch*******@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hi,

I need some help. I have created a form where there are 3 combo boxes
and a text box to search through records. Based on what the user fills
in, you then it a "go" button to run the query and obtain the search
results. This is all working correctly except for the fact that it
opens up the results in datasheet view.

What i want to happen is, when the user hits "go" to run the query, the
results are used to populate a list box on the same form.

Can anyone help me?

[chrisse_2]

Thanks for your quick response.

I have already made the rowsource porperty of the list box to the
query. I think the problem may lie in how i am getting my query to run.

At the moment, when the user hits "go" the following code runs:

DoCmd.OpenQuery "qrySearch", acViewNormal

lstResults.Requery

Is there another way to get the query to run?

[Bob Quintal]

ch*******@hotmail.com wrote in
news:11**********************@z14g2000cwz.googlegr oups.com:

Thanks for your quick response.

I have already made the rowsource porperty of the list box to
the query. I think the problem may lie in how i am getting my
query to run.

At the moment, when the user hits "go" the following code
runs:

DoCmd.OpenQuery "qrySearch", acViewNormal

lstResults.Requery

Is there another way to get the query to run?

Reread PC Datasheet's response. he told you exactly the command to
use.
--
Bob Quintal

PA is y I've altered my email address.

[PC Datasheet]

Delete the DoCmd line. When you requery the query will automatically run and
fill the listbox with the results.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<ch*******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Thanks for your quick response.

I have already made the rowsource porperty of the list box to the
query. I think the problem may lie in how i am getting my query to run.

At the moment, when the user hits "go" the following code runs:

DoCmd.OpenQuery "qrySearch", acViewNormal

lstResults.Requery

Is there another way to get the query to run?

[chrisse_2]

Thanks you were right the first time. It is not that i didn't try what
you wrote. It is that i did and it didn't work. But, i have discovered
the problem.

It was in the code for my reset button. I had to make the rowsource in
that code the query also. Where as before it was referencing the table.
As a result, after i hit reset it would not search.

Thank you so much for your help PC Datasheet. You have helped me
complete my database!!!!!!!!