Set Filter and FilterOn from a pop-up form

[sabre1]

I am having huge problems with the coding of using a pop-up form which gives the user options which they can select which then filters a report. I have tried to use a code that i found on the internet however i cannot seem to get it to work and i was wondering whether someone had a simple code using just one combo box and one button for now.

Here are a few details:


-Report i want to filter called Entity List
-Field i want in my combo box which is also on my report called Entity_Client from the table Entity_Info

Any help would be greatly appreciated thanks.

[maximus]

To filter the Entity_Client from a pop up form which is unbound and has a combox (e.g. combo0) with Rowsource Entity_Client run this code from the command button on the pop up form:

Dim strCriteria as String
Dim strDocName as String

strCriteria="[Entity_Client]='" & Me.Combo0 & "'"
Docmd.OpenReport "Your Report Name", acViewPreview, , strCriteria

Note: I have assumed that Entity_Client is a text field.