I'm creating a form that has a bound text box from a table, i just don't know how to tie that bound text box to my query so when the query runs it looks for whatever is in that box....
I'm creating a form that has a bound text box from a table, i just don't know how to tie that bound text box to my query so when the query runs it looks for whatever is in that box....
Last edited by jgomez; 01-08-2013 at 01:15 PM.
In your criteria in your query, type Forms!YourFormName.YourTextBoxName
Here is a fuller tutorial on search forms that uses this approach.
http://www.datapigtechnologies.com/f...earchform.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks Alan... I knew it could be done but had no clue how to...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks