Filter Form then Select a Filtered Record for view

  • Thread starter franklinbukoski
  • Start date
F

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.
 
F

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top