Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Unanswered: Filter and check box not working when form is put in sub form

    Strange problem I have an option group that after the update (3 choices) I set two variables to a date range and then I also include a a value for a field (boolean) as the remaining criteria for the filter

    the filter is below and works flawlesly as a form by itself

    Me.Filter = " [Projected Start date] Between #" & dtStart & "# And #" & dtEnd & "# AND [TWLA] = -1"
    Debug.Print Me.Filter
    Me.FilterOn = True


    If I remove the "and twla = -1 " and filter just by the date range - I can right click the check box and filter further for -1 0r 0

    When I embed the subform I get a double whammy of headache
    clicking the option group pops up a parameter value for the filed TWLA - which itdoes not when I use the form as a main form - in addition the check box is blue and does not allow me to filter - it has the exact properties of 3 other check boxes that function fine.

    Any ideas why I get this behavior?
    Dale Houston, TX

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Resolved

    Temp recordset I was getting from my main table and placing in the temp table did not have the TWLA field - but when I opened the form without the parent form it was looking at the main table - and I learned that bound check boxes to fields that do not exist are Blue LOL

    if you read this to try to help me - thank you
    Dale Houston, TX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •