R Ringers Registered User. Local time Today, 15:32 Joined Mar 4, 2003 Messages 54 Mar 5, 2003 #1 How do i setup a text field as a search field. ie enter in a string in txtbx_branch and have it look thorugh the relevant records it is related to. Any help with this would be great.
How do i setup a text field as a search field. ie enter in a string in txtbx_branch and have it look thorugh the relevant records it is related to. Any help with this would be great.
B bjackson Registered User. Local time Today, 15:32 Joined Jan 3, 2003 Messages 404 Mar 5, 2003 #2 create a query with the fields you need in the query,select the field that relates to txtbx_branch,which i assume is on a form and set its criteria =forms![yourform name]![txtbx_branch]
create a query with the fields you need in the query,select the field that relates to txtbx_branch,which i assume is on a form and set its criteria =forms![yourform name]![txtbx_branch]
