Query and subquery

[sd_eds]

I have an issue that I cant seem to find a solution for.

I have a query that I am using as the source for a report. Data for
the query comes from the applicant, job position, and interview
tables.
I want to dynamically extract records from the query and show the
records in a report. Basically I want to select the records in the
query based on job position.
I have a form that the user can use to select a criteria from the
query. Once a selection is made on the form, another query is run. I
cant seem to get around the fact that I can only pull a single record
with the subquery. I am not sure how to format the original query or
subquery so that I can pull multiple records to use as the source for
the report.

Thanks in advance.

 

[Guest]

It would help a whole lot if you posted your query SQLs.

 

[sd_eds]

I changed the subquery to a WHERE statement in the DoCmd.OpenReport
method and it seems to work.

DoCmd.OpenReport "rptReport", acViewPreview, , strWhereString

The only issue I am having now is that the labels on the report are
not getting updated after the selection is made.

Thanks