Re: [MS_AccessPros] Filtering a continous form with multiple combo boxes

 

Art,

It's not enough to say only "based on the selection made in the combo boxes". Do you want to filter by a single combo box if the user only selects a value in the cabinet combo box? I assume the subfolderID is unique and can only be found in a single folder and cabinet. So if a user selects a subfolder, you don't have to worry about filtering by folder or cabinet.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, February 8, 2018 2:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Filtering a continous form with multiple combo boxes

 

I have a from called frmDocumentDashboard on it I have 3 comboboxes:

cmbChooseCabinet - Select cabinetID, cabinetname from tblCabinets

cmbChooseFolder - Me.cmbChooseFolder.RowSource = "SELECT tblFldrs.FolderID, tblFldrs.FolderName FROM tblFldrs " & _

     " WHERE CabinetID = " & Nz(Me.cmbChooseCabinet) & _

     " ORDER BY FolderName"

 

cmbChooseSubfolders -   Me.cmbChooseSubfolder.RowSource = "SELECT tblSubfolders.SubfolderID, tblSubfolders.SubfolderName FROM tblSubfolders " & _

     " WHERE CabinetID = " & Nz(Me.cmbChooseCabinet) & _

     " ORDER BY SubfolderName"

 

Below these I have subform called sfrmDocumentListing which is a continuous form. Recordsource is 

SELECT tblDocuments.DocumentID, tblDocuments.DocumentName, tblDocuments.DocumentLocation, tblDocuments.DocumentFileType, tblDocuments.DocumentFileKBSize, tblDocuments.DocumentMemo, tblDocuments.CreatedDate, tblDocuments.CreatedTime, tblDocuments.FolderID, tblDocuments.SubFolderID

FROM tblDocuments;

I would like to be able filter sfrmDocumentList based on the selection made in the combo boxes. Please advise.

Thank you,

Art Lorenzini

SD

 

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___