Subform filtering - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Subform filtering

Dave McKee

3 years ago

Hi everyone

I have a question about subform filtering when using one form to open another parent and child form/subform. I have 3 forms:

A = continuous form with a list of customers
B = single form with single customer details
C = a continuous Subform (parent / child with B) with scheduled visits dates for each customer

SubForm C has a form-level filter applied in the Data tab of the Property Sheet - [VisitDate]>=Date()-14 Or IsNull([VisitDate]) - to display recent and upcoming scheduled visits. It deliberately does not display visits that occurred more than a fortnight ago.

When I open Form B directly in Access, subform C filters the records by date as expected. However, if I use Form A (full customer list) to open Form B (specific customer), Forms B and C load OK but subform C is no longer filtered by date.

Is it possible to have subform C filter the dates if the parent form (B) is opened by another form (A)? Thanks.

	Kevin Robertson @Reply 3 years ago
Add some filter code to the event that opens the form (similar to my code below). `Private Sub CustomerID_DblClick(Cancel As Integer) DoCmd.OpenForm "CustomerF", , , "CustomerID=" & CustomerID With Forms!CustomerF!VisitF.Form .Filter = "VisitDate>=Date()-14 Or IsNull(VisitDate)" .FilterOn = True End With End Sub`

	Dave McKee OP @Reply 3 years ago
Hi Kevin Many thanks, that worked perfectly.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View