Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
forms and sql in access
- Thread starter shanemjo
- Start date
Shane,
You can use Parameters in your query to reference data from a control in a form.
EG.
SELECT *
FROM tblTable
WHERE Field = [Forms]![frmYourForm]![txtYourTextBox]
Hope this helps.
Leigh Moore
LJM Analysis Ltd
You can use Parameters in your query to reference data from a control in a form.
EG.
SELECT *
FROM tblTable
WHERE Field = [Forms]![frmYourForm]![txtYourTextBox]
Hope this helps.
Leigh Moore
LJM Analysis Ltd
- Status
Similar threads
- Locked
- Question
