How do you use the value written in a control of a form as input for a query?
eg-if the user inputs 100 into an itemid text box on a form, i want to use 100 as input for a query.
I thought it was:
Forms![name of form]![name of control on form]
but Access automatically puts brackets around [forms] and then it comes up with a parameter query msg box with the caption: forms!name of form!name of control.
What am i doing wrong?
eg-if the user inputs 100 into an itemid text box on a form, i want to use 100 as input for a query.
I thought it was:
Forms![name of form]![name of control on form]
but Access automatically puts brackets around [forms] and then it comes up with a parameter query msg box with the caption: forms!name of form!name of control.
What am i doing wrong?