I am trying to utilize an unbound search text box to have users type in keywords which will filter a list box of clients to show only clients that meet the keyword criteria. However, the keywords will not reference the actual list box but rather the info in fields of various subforms.
I know that I need to have a SQL statement that changes the sort order/filters List367, but am unsure of how to go about this. I know that I need the following:
-Unbound search text box "Text85" where keywords will be entered
-Unbound list box of clients "List367" which should be filtered upon searching
-Keywords should reference the following fields in subforms:
-"ExtraNetProvider" in subform "EXTRANET" (upon keyword of "Extranet [keyword]" any clients with [keyword] in ExtraNetProvider should show up on list box)
-"Provider" in subform "DIRECT_CONNECT" (upon keyword of "Direct Connect [keyword]" any clients with [keyword] in Provider should show up on list box)
-"Via_Service_Bureau" in subform "Via_Service_Bureau" (upon keyword of "Service Bureau [keyword]" any clients with [keyword] in Via_Service_Bureau should show up on list box)
-"On_Behalf_Of" in subform "On_Behalf_Of" (upon keyword of "On Behalf Of [keyword]" any clients with [keyword] in On_Behalf_Of should show up on list box)
-"chkDirect_Connect" in subform "Master_Key" (upon keyword of "Direct Connect True" if chkDirect_Connect is true then should show up on list box)
-"chkDR" in subform "Master_Key" (upon keyword of "DR True" if chkDR is true then should show up on list box)
chkDR_Direct_Connect (upon keyword of "DR Direct Connect True" if chkDR_Direct_Connect is true then should show up on list box)
-"DR_DC-Provider" in subform "DR_DIRECT_CONNECT" (uponkey word of "DR Direct Connect [keyword]" any clients with [keyword] in DR_DC-Provider should show up on list box)
-"DR Extranet_Provider" in subform "DR_EXTRANET" (upon keyword of "DR Extranet [keyword]" any clients with [keyword] in DR_Extranet_Provider should show up on list box)
I know that I need to have a SQL statement that changes the sort order/filters List367, but am unsure of how to go about this. I know that I need the following:
-Unbound search text box "Text85" where keywords will be entered
-Unbound list box of clients "List367" which should be filtered upon searching
-Keywords should reference the following fields in subforms:
-"ExtraNetProvider" in subform "EXTRANET" (upon keyword of "Extranet [keyword]" any clients with [keyword] in ExtraNetProvider should show up on list box)
-"Provider" in subform "DIRECT_CONNECT" (upon keyword of "Direct Connect [keyword]" any clients with [keyword] in Provider should show up on list box)
-"Via_Service_Bureau" in subform "Via_Service_Bureau" (upon keyword of "Service Bureau [keyword]" any clients with [keyword] in Via_Service_Bureau should show up on list box)
-"On_Behalf_Of" in subform "On_Behalf_Of" (upon keyword of "On Behalf Of [keyword]" any clients with [keyword] in On_Behalf_Of should show up on list box)
-"chkDirect_Connect" in subform "Master_Key" (upon keyword of "Direct Connect True" if chkDirect_Connect is true then should show up on list box)
-"chkDR" in subform "Master_Key" (upon keyword of "DR True" if chkDR is true then should show up on list box)
chkDR_Direct_Connect (upon keyword of "DR Direct Connect True" if chkDR_Direct_Connect is true then should show up on list box)
-"DR_DC-Provider" in subform "DR_DIRECT_CONNECT" (uponkey word of "DR Direct Connect [keyword]" any clients with [keyword] in DR_DC-Provider should show up on list box)
-"DR Extranet_Provider" in subform "DR_EXTRANET" (upon keyword of "DR Extranet [keyword]" any clients with [keyword] in DR_Extranet_Provider should show up on list box)
