MS Access gurus?

[Pandamonium]

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]

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.