Filter Form then Select a Filtered Record for view

[franklinbukoski]

I have a main form with multiple subforms that make up an employee
information screen. This form is tied to tables, no queries.

To access the form, I have an unbound listbox on another form that I choose
either Active, Inactive, or Pending Gain from, and have the on click event
property set to run a macro that opens the main form and applies the filter:
[recordstatus]=[Forms]![SelectTypeRecord]![list11] at the where condition of
the macro.

I then have an unbound combobox on the main form set to find a record on my
form based on the value I selected in my combobox...but the combobox shows me
ALL records in table, not the filtered records displayed on the form.

 

[franklinbukoski]

I figured it out, for anyone else with a similar issue:

Combobox Property, Data Tab, Row Source (WHERE CLAUSE AT END IS WHAT FIXED
MY PROBLEM):
SELECT tblPersonnelData.PersonnelDataID, tblPersonnelData.RankID,
tblRank.Rank, tblPersonnelData.LastName, tblPersonnelData.FirstName,
tblPersonnelData.MI FROM tblRank RIGHT JOIN tblPersonnelData ON
tblRank.RankID=tblPersonnelData.RankID WHERE
(((tblPersonnelData.RecordStatus)=Forms!SelectTypeRecord!List11));

Format Tab, Column count 6, column widths: 0";0";0.5";0.8";0.5";0.3"