Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo box to filter a subfolder (2003)

    I have a combo box to filter a form recordset. The name of the form is form2. Form2 is a subform of form1 (see the attached file).
    If I open form2 alone, the combo box works perfectly and filters the recordset.
    If I open form1 and try to use the combo box nothing happens, the event afterupdate is not called and the combo box list stay open. The code behind the combo is very simple:
    Public Sub Combo17_AfterUpdate()
    Dim myCriteria As String
    myCriteria = "[Date Cde] < #" & Format(Me![Combo17], "mm/dd/yyyy") & "#"
    Me.Filter = myCriteria
    Me.FilterOn = True
    End Sub

    Thank you for your help,

    Marcel
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo box to filter a subfolder (2003)

    Open the main form (form1) in design view.
    Click once on the subform to select it (don't click a second time, for that will select something within the subform.)
    Has the Locked property (in the Data tab of the Properties window) been set to Yes?
    That would make selecting an item from the combo box impossible.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo box to filter a subfolder (2003)

    Hi Hans,

    I check your option and yes the Locked property was set to Yes and moreover the allow Edition was also set to No.

    I change them and it works,

    Thanks for your help, regrads,
    Marcel

Posting Permissions

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