Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-30-2018, 04:35 AM   #1
LeslyP
Newly Registered User
 
Join Date: Apr 2018
Posts: 28
Thanks: 12
Thanked 2 Times in 2 Posts
LeslyP is on a distinguished road
Search (filter) form searching in "Multivalued field" (many-to-many)

Hi !

for you who is looking to make a multicriteria search form with combobox and textbox to filter multivalued field you are a the good place. It is not perfect (I'm not a expert), but it works, at least. However, if you select "blue" everything that contains "blue" will appear. Better then nothing ?

You will have to change your multivalued fields into many-to-many relationships. And don't use lookups !
Attached Files
File Type: zip Search_Multi.zip (215.8 KB, 176 views)

LeslyP is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating "Months" in "Search Form" alakbd Forms 2 09-25-2014 03:32 AM
Incremental Search (aka "Searching List Box" DataMiner Forms 12 11-06-2011 04:11 AM
"Invalid Argument" error when VBA exporting to text a multivalued field world33 Modules & VBA 3 10-10-2010 04:09 AM
Filter By Form showing only "IsNull" and "IsNotNull" lilachva83 General 1 11-22-2008 10:52 PM
Filter By Form showing only "IsNull" and "IsNotNull" vangogh228 General 7 06-14-2002 01:06 PM




All times are GMT -8. The time now is 09:42 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World