Combobox to Filter Viewable Records on Form

[IH8XEL]

What's up guys?

Bear with me here...I have one table and one form. One of the fields (Entitled: PFCStatus) in my table lists the records' status as "Active," "Inactive," and "Declined." The form has navigation buttons (i.e., previous record, next record) and search combo boxes so that users can find individual records as well as navigate through each record.

I have been asked to create a combobox in the header of the form that users can use to select the status of a record, the Active, Inactive, and Declined status from the PFCStatus field. The idea is to have the user select which status they want and then be able to use the navigation and search boxes to go through every record that has the selected status.

Is this possible? Does it make sense? Do you need more info?

I cannot share the database on here because it has HIPAA related info on it.

HELP ME!!!!!!!

 

[alansidman]

Here is one option. https://support.microsoft.com/en-us/kb/304259
Here is another option. filtering microsoft access records based on combo box predefined values - Stack Overflow
and lastly here is a video. https://www.youtube.com/watch?v=Sr-AWPGJbgo

 

[ranman256]

i have a table with the choices and query.
"Active," ,qsActive
"Inactive," ,qsInActive
"Declined.",qsDeclined

the user picks the 'shown' value, Declined, but the combo is assigned to col 2, which reads the query.
so just execute the combo
me.rowsource = cboFilter

 

[IH8XEL]

I'm not exactly Access savvy. Would you mind elaborating?