Search results

Someone ended up pointing me to a solution with a nice simple bit of VBA: If Me.tgl_Complete_Incomplete = -1 Then Me.Filter = "[Completed]=-1" Me.FilterOn = True ElseIf Me.tgl_Complete_Incomplete = 0 Then Me.Filter = "[Completed]=0" Me.FilterOn = True Else Me.FilterOn =...

OK, so I took your advice and took a closer read of what it wants. I had been trying to reference the control within the subform, but am I right in thinking that I should instead reference only the control that contains the subform? If that's the case, I've tried...

That's the problem: I'm not sure what it wants. I know I need a valid control name, but I don't know the proper way to construct it. From what I've been reading online, it sounded like I needed to reference the control within the subform (referencing the subform control on the main form to get...

OK, so where did I go wrong? I had thought the line [Forms]![Search_by_name]![sfctlActionItems].[Form]![tgl_Complete_Incomplete] was referencing the control on the subform, but I guess I'm off base. Sorry, I'm learning Access as I go here, and I can't find much help online for my problem...

I have a tab control at the bottom of my main form, and some of the tab pages contain subforms. On one of the subforms I have created a filter to divide the content into "complete" and "incomplete." I have also added a toggle button option group to the subform to toggle the filter (one button...