Expert: Scottgem - 7/1/2009

Question
Hi,

I have a question, I am trying to link a query's criteria to a form, so that when I type a number into the form, that number will be my criteria when I activate a query.I tried building different expressions in the criteria and I also have a form with a textbox which the user can key numbers into, but I am having trouble trying to get that to work. Hopefully you can help. Thanks in advance.

Answer
You can reference a value in a control on an open form using the syntax:

Forms!formname!controlname

where formname is the name of your form and controlname the name of the control who's value you want to reference.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA