MS Access gurus?

Pandamonium

Golden Member
Aug 19, 2001
1,628
0
76
I have a relational database with 3 tables: "service calls", "contacts", "printers". Two fields in "service calls" have many-to-one relationships with ID fields in "contacts" and "printers".

The wizard make a form that displays fields in calls. Here's where it gets hairy though. I want to have two combo boxes for the "contacts" and "printers" ID fields that narrow down the list of queries available to that form when they're selected. I couldn't find anything promising on google, and was hoping someone here might be able to point me in the right direction.
 

KLin

Lifer
Feb 29, 2000
30,194
554
126
Create the combo boxes, and make a filter button to filter down the form's recordset to what's in the 2 comboboxes.

http://groups.google.com

search the newsgroups, lots of MS Access information can be had there.