Query Troubles

[AJ]

I'm having a query problem. I know what is happening, but I don't know how
to fix it. My table has 4 fields, column 1 = Index #, column 2 = Team
Leader, column 3 = username, column 4 = email

I have a form set up for data entry by selecting from a combo box which
pulls from column 2.

I have the query set up with criteria such that the dialog box states "enter
team leader".

The query is looking for something from column 1 which is the Index # not
from column 2 which is the team leader.

The user will not know the Index #, so I need to know how to get the query
to pull from the team leader (column 2) field.

Thanks in advance to anyone that can help!

 

[AJ]

Through experiments I have the form and query working. Now... my report
doesn't work. How do I set the report to populate from the info from the
query now?

thanks

 

[RipperT]

AJ,
Exactly what's not working? Have you tried the report wizard?
Need more info.
Ripper

 

[AJ]

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the query in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view, how
to keep the dialog box from opening and how to get the info from teh query in
the report. (the report is set up to pull from that query).

thanks for any help you can give.