Hello,

I had this dialog box working, but now it does not filter.

Would anyone be able to look at the frmNIEHS_Rpt_by_SM_dialogBox in the attached *.mbd?

**It seems to bring up all the studies, but when a "Study Manager I" is selected and "Apply Filter" clicked, it does not filter. (It should, e.g., display 2 entries for Long, Elizabeth...)

I have checked my VBA code, etc, but have not been able to figure this one out.

any help much appreciated,
SJ

Basically your problem is that you are trying to filter on a combo box on the report, which won't work. You need to filter on the RECORDSET of the report. Also, you shouldn't be using a value list for names in a combo box as those names can change. You should be basing it on a table. Plus, combo boxes have no meaning in reports.

Bob,
thanks for your input.

Since I am new to this, I used this example: http://www.fontstuff.com/access/acctut19.htm

Looking at what you said. I "need to filter on the recordset". What are you referring to here (...basing it on a table, not on a list?)

You also state that "combo boxes have not meaning in reports". I'm not understanding this.

How can I allow managers to run a report for their projects?

thanks in advance,
sj

Basically your problem is that you are trying to filter on a combo box on the report, which won't work. You need to filter on the RECORDSET of the report. Also, you shouldn't be using a value list for names in a combo box as those names can change. You should be basing it on a table. Plus, combo boxes have no meaning in reports.

Bob,
I'm confused. The record sources for my combo boxes (Study Manager I, and II) are Queries (which are based on my Study table). Is this not basing my combo box on a table?

Maybe what you're telling me (and I'm not understanding) is to change my TABLE's row source type to "Qry/Table" from Value List. So...I would change my row source to: the table (itself, i.e. tbl_study), and then choose to update all the lookup properties everywhere that the Study Manager name is used (?)

thanks for any clarifications,
Sj

Bob,
I'm confused. The record sources for my combo boxes (Study Manager I, and II) are Queries (which are based on my Study table). Is this not basing my combo box on a table?
I was talking about the combo on the report, not the form. And, that is moot anyway because a combo is not interactive on a report and therefore shouldn't even be used on a report.