row source for a combo box
Competent Performer
Windows 7 64bit 
Access 2010 32bit
Hello, On a form, the user enters the last 4 digits of the phone number into a text box. As an example, if the user entered 0021, in a normal query, in the criteria field I would enter like *0021. How do I use that same logic in this row source: [Forms]![frmSearch]![txtPartialPhone]
Competent Performer
Windows 7 64bit Access 2010 32bit
I figured it out. Here's what is working, Like "*" & ([Forms]![frmSearch]![txtPartialPhone])
Set record source of a subform combo filter to null when adding new record
How to refresh a row source in a combo box from a query ?
How to use a combo box value as part of a query which is a report source?
Calling To a Combo Box By Row Source, Not Value List
Posting Permissions
Reply With Quote