Query Question

Is it possible to call a value from a form within a query?  I am trying to get my database setup so that when a user types in some value in a text box on my form and clicks on the execute button, the relevant records are returned.  I had it working perfectly, but I recently had to change from one table to two as I was at the 2GB limit.  With the help of some people here I got that working perfectly through a query, but when I try to incorporate that into my form, it won't work.

As I said, the query itself works fine.  The query is below:

SELECT *
FROM cbsofeed_more WHERE [Corp_ID_Control_Acct] = [frmReportParameters].[txtFindAccount]
UNION SELECT * FROM cbsofeed_less WHERE [Corp_ID_Control_Acct] = [frmReportParameters].[txtFindAccount];

As you can see I am calling a value from my report, txtFindAccount.  When I run the query by itself a box pops up asking for the info.  I can put data in there and the appropriate records are returned.  When I try to incorporate the query into my form, the box still pops up asking for txtFindAccount even though the value is provided on my form.

Another problem is how to get the results to appear in my subform.  When I try the following I get an error message telling me a "=" sign is expected.  Not sure what that means.  Code is below:

Me!subBlank.Form.RecordSource = DoCmd.OpenQuery(Find_Corp_ID_Control_Acct)

Any help will be greatly appreciated.

Thanks.Start Free Trial