I am currently working on a small site that will use an Access database and cannot figure out how to let a person query my database from drop down boxes.
The site is interactive so I cannot pre-fab the queries...
If anyone could tell me how to make a combo box contian values from an Access column and then query from those user selected values that would be super. (i.e. If they choose "blue", "oak", and "set" - they could see all furniture that is "blue", made of "oak" and in a complete "set".
I was using Data Access Pages for this but it becomes really ugly and time prohibitive in my opinion!!??
