M
malik via AccessMonster.com
How can i change query criteria by a form text field....??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to change query criteria by a form text field....??
T
Tom van Stiphout
On Sat, 24 Jan 2009 20:57:04 GMT, "malik via AccessMonster.com"
If I understand you correctly you want to limit the rows returned from
a query by the value in some text field.
Create a query:
select * from myTable
where myField = Forms!myForm!myTextbox
(of course you exchange myObjectNames with yours)
-Tom.
Microsoft Access MVP
If I understand you correctly you want to limit the rows returned from
a query by the value in some text field.
Create a query:
select * from myTable
where myField = Forms!myForm!myTextbox
(of course you exchange myObjectNames with yours)
-Tom.
Microsoft Access MVP
J
John W. Vinson
How can i change query criteria by a form text field....??
Just use a criterion in your query
=[Forms]![NameOfForm]![NameOfTextbox]
T
troy23
=forms!formName!ControlName
For FREE Access ebook and videos click here
http://access-databases.com/ebook
For FREE Access ebook and videos click here
http://access-databases.com/ebook
M
malik via AccessMonster.com
Thanks for ur Kindness