filter sub form with combo boxes (1 Viewer)

aussiehedge

Registered User.
Local time
Today, 21:20
Joined
Nov 24, 2006
Messages
10
I have read many post on this and I just cant crack it.
Not understanding vba well i have tried to copy paste and adjust.
I need to filter a subform based on 3 combo boxes. The main form is LCLForm and i have attached a copy of the database.
The filter should kick in after the After update on all 3 combo boxes.
 

Attachments

  • Database2 - 7.accdb
    800 KB · Views: 41

aussiehedge

Registered User.
Local time
Today, 21:20
Joined
Nov 24, 2006
Messages
10
Mate you are the best! I can believe i was stuck on that for days. changed the indexing to no duplicates and bang all fixed!
 

isladogs

MVP / VIP
Local time
Today, 10:20
Joined
Jan 14, 2017
Messages
18,186
Pleased you solved it. Not sure how that was based on my comments though ;)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:20
Joined
May 7, 2009
Messages
19,175
i will solve it for you
 

Attachments

  • Database2 - 7.zip
    54.9 KB · Views: 40

Users who are viewing this thread

Top Bottom