Data parameter value issue

[AccessNewby]

I am trying to create a query and my data source is from a "1st" query. My new query consists of two fields (Account number & Account Name) and I want to use this two fields as a combo box for my form layout. My issues is that one of the field from the "1st" query is the "Date" field and it has a parameter date value. When I run my new query I get "Enter parameter value -begin and end date" although my new query does not contain the "date" field from the 1st query. Hope that I did not confused you.

Could someone help me with this.

Thank you.

 

[dkinley]

I would opine that it didn't matter whether you were using the date field in the 2nd query or not. I state this because your 1st query is using the input parameter and that query has to be populated with records in order to populate the 2nd query.

The only way I can think of around this is to copy the 1st query, remove the unnecessary fields and use that query in your 2nd query.

-dK

 

[boblarson]

dk hit that on the head!

 

[AccessNewby]

Thank you both