Access Unbound Combobox Lookup on form using 2 parameters
Posted on 2008-10-13
I know how to make a combo box using one parameter to pull records into a form but am working with a table which uses 2 fields as primary key and so I need to do something like this for both PK fields to pull up a unique record. Is there a way to have 2 combo boxes; one with the first parameter and then the second with the second parameter to pull up the records?
Here are some specifics:
Form Source: COMBINE - This is a query which pulls two tables, MEMINFO and PROPINFO together.
Fields: The query has all of the fields of both tables which are as follows:
MEMINFO: MEMNUM (PK), MEMNAMEL, MEMNAMEF
PROPINFO: MEMNUM (PK), SFX (PK), STATUSPD, PROPADD1, PROPADD2, PROPADD3,
My goal here is to select the MEMNUM and SFX from the two combo boxes (one would work as well but I think that two would be a more elegant choice with SFX populating based on the record chosen in MEMNUM) and have the rest of the form populate. The main form ill be used for display rather than data entry with a subform based on the selected record being used to enter transactions associated with these records. I am not sure if there is a way to do this with the combo boxes alone or if a button needs to run a script once the boxes are populated but I m not adverse to either solution.
Caveat: I know my way around Access for the most part but am a true novice when it comes to anything relating to coding.
Thank you in advance, Jim.