Open Report linked to Query Issue

[McArthurGDM]

So I have an Unbounded Form with various inputs. I have a query, SearchQ, that takes these inputs for specific criteria.

If I run the query, the query itself pops up in datasheet view - which is useless to me since I want to generate a report off of this specific search.

When I run the query, and then try to run the Report, I get an error message - as such. NOTE: When I close out of the query itself the error goes away most of the time.

I created a macro that runs the query -> closes the query -> closes the form -> opens report. I tried creating two commands that also just runs query -> closes query AND ANOTHER button that closes form -> opens report.



I keep getting this same error no matter what I do and I have no idea why. The error might be linked to a security issue - but I honestly dont know.

Thanks

PS - I KEEP GETTING THIS ERROR IF I CLOSE THE FORM AND QUERY, OR NOT. My report just isn't popping up anymore....

[June7]

There is no need to 'run' query, just open report that uses the query as RecordSource.

The unbound controls are to input filter criteria? How are you applying the parameters?

Are you using dynamic parameters in query?

BTW, advise no spaces or special characters/punctuation (underscore is exception) in naming convention. The # character is bad. Better would be RefNum_ID or RefNo_ID or RefNoID.

[McArthurGDM]

The unbound form is there to take input for the query.

ie

[forms]![SearchF]![ComboBox2] or something.

Then, after you perform the multi-field search criteria... to be able to open a report with records relevant to the search criteria.

It's not working for me. I have the query as the record source of my report so Im not sure what's wrong.

[June7]

Example of report based on dynamic parameterized query referencing form controls for input http://www.datapigtechnologies.com/f...mtoreport.html

However, if Ref# ID is a number, this method will probably not work as desired. For VBA alternative, review http://www.allenbrowne.com/ser-62code.html

[McArthurGDM]

I haven't been able to implement it yet, but that first link you sent is exactly what I was looking for. It's a bit more complicated than just linking to a query and setting the value of the combo box to regular table values is what I believe was causing my issues. I hope this works tomorrow!

Thanks

[McArthurGDM]

Unfortunately, this didn't work today.

First off, I have multi-value fields in my Main table. I am not going to change this. I am confident one can work around multi-value fields. I have had success so far (with a headache).

I am doing everything that he is doing in the video. The ONLY thing that changes is that when I link to my ContentsT table, it creates a new field in the query (as you can see) called Content.Value - it gets rid of whatever I inputted originally in the Content field in the query and replaces and adds with that new field.

This is something that happens with multi-value fields. It calls upon a particular value of the Contents table. I get an error (the same error as before) when trying to execute the "Run Report" command.

Here are the images of what I have below. It is worth noting that I created a macro for the Run Report command to close out the form and open the report itself.

[June7]

Ouch! I NEVER use multi-value fields so I have little experience with them. I've never tried to apply filter criteria to multi-value field nor build report with them. I don't know why that error is triggered. You may be on your own here.