Search results

What will be the code I will put at Select All and De-Select All buttons?

Great. One more thing. Can you do if all is checked show all records(Select All), if none are checked dont display anything (De-Select All).

The subform table is not filtering right. The checkboxes are only filtering one at a time.

Attached is my sample DB. The checkboxes are in frm_Dependent_Search in Search Tab.

the MsgBox is not prompting the message

How to post sample DB in here?

The immediate window is empty

There are 5 checkboxes that filter the 1st column CRN and there is a subform containing a table the will be filtered depending on the checkboxes ticked or unticked.

What do you mean DB? Sorry I cannot attach the DB here.

Here's the code strive taught me. Private Sub chkIndigent_AfterUpdate() Call SetMyFormFilter End Sub Private Sub chkPWD_AfterUpdate() Call SetMyFormFilter End Sub Private Sub chkRegular_AfterUpdate() Call SetMyFormFilter End Sub Private Sub chkSenior_AfterUpdate() Call SetMyFormFilter End...

What I must do now? pls help.

one thing. i did not put the option explicit because its causing error when compiling. Is that ok?

ok strive. thanks. who can help me?

there is only one field which is CRN. Where do i place the "Debug.Print vFilter "? I dont know how to code the query. can you make an example please and where to put it. please help im completely lost and new to access. please be patient with me.

yes strive I've already done that with all checkboxes

hi strive. nothing is happening when i ticked and unticked the checkboxes... is this have to do with line " .Filter = vFilter .FilterOn = True "?

also the line is automatically placed after the option explicit statement

thanks strive. also if i put the "Option Explicit ' require variable declaration" on top of the code its saying " only comments may appear after End Sub, End Function, or End Property.

Hi MajP. Can you tell me what is wrong with strive's code the compiler is saying syntax error in lines vFilter = (vFilter + AND ")

hi strive, the compiler is returning syntax error in line vFilter = (vFilter + AND ")