Form with ComboBox Filter in Header

[CRIMEDOG]

I have a "multiple items" form that I created.
There is a combo box in the Header - that I want to use to filter the Table with --I pointed the form to a Table (not a query) because I want to edit the info.
I have the action set for "after update" to run this code:

Please Login or Register  to view this content.

the OrderMonth field in the Table is a calculated field =Month([OrderDate]) where OrderDate field is a field with the Date/Time entry format

I would like to have the name of the month (January,February...) be the choice in the comboBox - then the Form would be filtered by that month

[alansidman]

Have you already built the combo box and populated it or is this something that needs to completed? I am slightly confused by your request. If it is the former, then you will need to create a table with a PK of 1 through 12 and a second field with the names of the months beginning with January. Use that table as the record source for your combo box.

Look at the three videos on the link below regarding combo boxes. This will show what you need to do to create and use combo boxes.

http://www.datapigtechnologies.com/AccessMain.htm

Alan

[CRIMEDOG]

Great links - Got it working

[CRIMEDOG]

Now - I have it working where it filters by OrderMonth I need to add filtering by OrderMonth & OrderYear

Please Login or Register  to view this content.

Getting Type Mismatch error

[CRIMEDOG]

also - if there are no matching order it shows the list as blank