Filter a continuous form using a combo box

[Chky071]

I am running access 2007 and have a continuous form that I am trying to filter. The table that I am pulling the data from has the following fields: Order_Date, Order_number, Model.

I want to filter based on Order_Date.

I tried creating an "after update" Macro builder on my combo box and using "Apply Filter" but I cannot seem to get my syntax right.



Filter is the name of my combo box

Here is my current setup:
Filter Name:
Where Condition: [Order_Date] Like [Filter]
Control Name:

However whenever I select a new date from my combo box it asks me to "Enter Parameter Value" for Filter, which I don't understand because my combo box name is Filter. I would think they would link up.

Any help would be appreciated

Thanks

[ranman256]

Me.filter = "[orederDate]=#" & cboDate & "#"
me.filterOn = true

[Chky071]

ranman256 thanks for you help.

Inside of design view I clicked on "view code" I added the text that you recommended, but changed the fields to match my form. However when I select a date from the combo box it does nothing.

Here is the code:
Option Compare Database


Me.Filter = "[BUILD_DATE]=#" & Filter & "#"
Me.FilterOn = True

"Option Compare Database" was there when I opened "view code"
"Filter" is the name of my combo box so I put it in place of cboDate

Thanks

[NoellaG]

Hi,

'filter' is a reserved word for Access. It is never a good idea to give your fields/controls a reserved name. You can rename your filter combobox to something like cboFilter.

[Chky071]

Hi,

'filter' is a reserved word for Access. It is never a good idea to give your fields/controls a reserved name. You can rename your filter combobox to something like cboFilter.

Thanks for your help. I made the change and it still does nothing. I inputed the code and when I change my combo box nothing happens. Any help would be appreciated.

[ItsMe]

It seems you have placed your code outside of a subprocedure and close to the top of the module, within the module header.

Your code should go in an event handler. To create a subprocedure for the click event of a command button, use the properties sheet while in design view. The Event tab within the properties sheet lists all of the available event handlers for the corresponding Object/Control.

Select your Command Button by clicking it and highlighting it. Locate the On Click event handler. To the right of the event, click the ellipses (...) and select the option for Code Builder. Click OK. Paste your code within the event subprocedure, before the line of code, "End Sub".