Filtering form data with check boxes

[Bkper087]

Building a budget database and have run into an issue. I have a column in the main table that is built as a foreign key field. This describes the entry as “Budgeted” (1), “Actual” (2), or “Forecasted” (3). On the main entry form I have three check boxes labeled “Budgeted”, “Actual” and “Forecasted.” The goal here is when the check box is checked, the subsequent entries shown in the bottom half of the split form will filter to only include that category. The catch is I want to be able to check more than one. That’s where I can’t get it to work.

It’s been a little while since I’ve used access to any great length. Can someone help re-train my brain?

[June7]

Consider:

Dim strC As String
With Me
    If .Budgeted Then strC = "1,"
    If .Actual Then strC = strC & "2,"
    If .Forecasted Then strC = strC & "3,"
    .Filter = "fieldname IN(" & strC & ")"
    .FilterOn = True
End With