Set default value of a textbox in a form

Hi Experts,

I have a form frmA. In this form I prompt the user to enter a caseID that will match to myTable.caseID.
When I click on Enter botton on frmA, another form frmB will pop up with a textbox myTextbox
I want to set the default value of this textbox to be the value of myTable.aValue that matches with the caseID that user keys in in frmA.

So I designed a query:

SELECT myTable.aValue
FROM myTable
WHERE (((myTable.caseID)=[Forms]![frmA]![txtEnterCaseID]));

This query alone works fine. But when I put it in the "Default Value" property in frmB. It doesn't work. In fact, it shows a #Name?

Can anyone help me with this?Start Free Trial