View Full Version : Filter Lookup by Form Field


Melissa Gelley
03-02-2005, 12:25 PM
I am trying to figure out how to make a pop-up box in my form filter by a field on the form.

I have a form with a Building ID where I choose Equipment Designations and then am able to enter additional information about that equipment. I have several buildings within the database with specific equipment for each building in an Equipment Inventory.

In the form the Equipment Designation is a pop-up lookup based on the Equipment Inventory table. I want to filter this list based on the Building ID that I choose in the form. Right now all the equipment for all the buildings is listed and it is not very efficient.

Stan Mathews
03-02-2005, 12:36 PM
Can you be a little more specific than "a pop-up box"? Are you referring to a combo box, list box, something else?

Stan Mathews
03-02-2005, 12:38 PM
Sorry, I didn't read the part about the "lookup" correctly. Consider changing to a combo box which is easily filterable.