Using Form textbox values in a query to be referenced by a chart

[Nancy]

I'm trying to figure out how to get information from a table onto a chart via a query that uses as it's criteria values contained in text boxes from a form when the form is run.

I'm referencing the query when the chart is created, so it refers to the query items in the Transform statement. The form prompts the user for information via a list box, then runs the chart. When the chart appears on the screen, it's empty.

When I run the query by itself to test it, the parameter boxes appear, and I manually enter the values. The data appears in the datasheet of the query just fine.

Alternatively, I'm inserting records into a temp table via the code in the form right before running the report program with the chart this time referencing the temp table. Doing it this way gets the results I want, but I'd much rather avoid the temp table and use just a query.

Anyone know the secret to accomplish this?

 

[Richie]

Sounds as though the forms reference is incorrect, post the criteria.

 

[Nancy]

Rich,

Thanks for replying.

I'm using the following in the criteria box of the query.

[Forms]![frmCoverChart]![txtSiteName]