Filtering a Continuous Form

[sbrookebounds]

I have a basic continuous form in Access 07. It has the following fields:
Serial #, Part Number, Model #
I want to put combo boxes in the header to filter the form. I have a combo box for each field. I named them:
SerialSearch, PartSearch, ModelSearch
The combo boxes are based on tables to automatically update when a new serial, part, model # is added. So, I got this far, so now I have a continuous form with three combo boxes in the header. I can select a value from the combo boxes. I have tried to put in code for the filter. It will filter perfectly in the ModelSearch combobox, but the others will not. Attached is my database. If someone could please take a look, it would be a great help. It will open to the form that needs help. Thank you!

[RuralGuy]

Can you compile this db without errors? I cannot.

[sbrookebounds]

not sure what you mean??

[RuralGuy]

From the database window, press <ALT> F11 and then Debug>Compile and see if there are any errors.

[sbrookebounds]

It was an error from another form I had been working on. It is fixed now. Try this copy.

[RuralGuy]

Here is a good link to start on: http://www.mvps.org/access/lookupfields.htm