Help with Filtering

[M_Mike]

I want to filter the information displayed on a form using the values I select in text or combo boxes.

I want to filter the form using one or more of the following options.
Call Ref - text box
Location No - Combo box
Area - combo box
Status - combo box

The combo boxes are taking their values from other tables within the database.

Can anyone help me develop the code needed to filter the form.

Thanks

 

[ejstefl]

Check this out: http://www.fontstuff.com/access/acctut19.htm

The tutorial is written from the perspective of a report, but can be easily adapted to a form.

 

[M_Mike]

That looks like exactly what I need. I'll try it as see if it works.

Thanks again.

 

[M_Mike]

I have entered the code into the database but when I click the apply filter button I receive the following error message: Run-Time error '2001': You canceled the previous operation.

I am unsure as to how to correct this but the problem seems to occur at the point when the filter is applied using the code below:

With Forms![frmFault]
.Filter = strFilter
.FilterOn = True
End With

I would appreciate any help or suggestions.
Thanks

 

[ejstefl]

There doesn't appear to be anything wrong with the code you've posted. Is the form open? Can you post the rest of the code? Have you tried debuging and seeing where the actual error was occuring?