User Profile

Collapse

Profile Sidebar

Collapse
The_Monkey
The_Monkey
Last Activity: Aug 3 '06, 07:52 PM
Joined: Jul 29 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • The_Monkey
    replied to Combobox to filter table using a date
    in Access
    Many thanks for your help.

    I did try that but did not work for some reason. I have been struggling with this for a week and then I tried the following code and it worked perfect.

    'Turn Filter off
    [Form_Record Activity].Rec_Act_Subfor m.Form.FilterOn = False
    'Assign Combo box value to variable
    Date = [Form_Record Activity].Week_Ending
    'Set Form Filter to value of Combo Box variable
    ...
    See more | Go to post

      Leave a comment:

    • The_Monkey
      started a topic Combobox to filter table using a date
      in Access

      Combobox to filter table using a date

      I have created a form with a combo box to filter a subform using a date.

      The filter works great but not with dates starting with a 0 e.g 01/07/2006

      I have set the format to short date for the combo box, the table that feeds the combo box and the subform to be filtered.

      I have also set the format in the code see below.

      Private Sub Week_Ending_Aft erUpdate()

      [Form_Record Activity].Data_Subform.F orm.FilterOn...
      See more | Go to post
      No activity results to display
      Show More
      Working...