Query in a subform

[54]

I have developed a form, that based on a selection in a textbox, lists values in a listboks. This works fine.<br>I have also a subform in my form, that uses the same query, based on a selection in another textbox, belonging to this subform. When I try to run this, I get a &quot;Enter Parameter Value&quot; - msgbox. This does not happen with the mainform.<br>What can I do to stop this msgbox from appering??<br>

 

[Chopper]

If the textbox the subform is using is on the subform, then you have to refer to it in the query via the main form.&nbsp;&nbsp;As in:<br>forms!frmMainForm!SubformWindowOnMainForm!txtTextBoxOnSubform<br><br>If you refer to the textbox through the subform(forms!frmSubForm!txtTextBoxOnSubform), the query does not recognize the name, assumes it is a parameter, and asks you to supply it. <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>

 

[54]

Thanks a lot!<br>Now it is working propperly!!<br>