hi. I would like my users to have the option of selecting a client (cboClient) and then to select a job type (cboMeasureType) and then have a report open up with that information in it. How would I do that. I currenty have the following in a command button but it does not work.

DoCmd.OpenReport "rptECM one page", acViewPreview, , "[Client Name] = " & "'" & Me.cboClient & "'" & "[Measure Type] = " & "'" & Me.CboMeasureType & "'"

I know that the following code works because it is in my program:
DoCmd.OpenReport "rptECM one page", acViewPreview, , "[Client Name] = " & "'" & Me.cboClient & "'"

I am not using any queries...I know, I know. I just didn't need one (so far). Can anyone help???

DoCmd.OpenReport "rptECM one page", acViewPreview, , "[Client Name] = " & "'" & Me.cboClient & "'" And "[Measure Type] = " & "'" & Me.CboMeasureType & "'"

does anybody have any idea on how I can use 2 combo boxes to create a link to a report that will ONLY open the chosen (from the combo boxes) fields???

thank you...i guess we both posted at the same time...I tried that but it gave me an error: TYPE MISMATCH ??? any idea why

I could have sworn I just answered :confused:

You're referring to the bound fields of the combo boxes, are they both numeric or text?

they are combo boxes that contain text

Just one column in each?

yup, one each. They are also unbound

DoCmd.OpenReport "rptECM one page", acViewPreview, , "[Client Name] = " & "'" & Me.cboClient & "'" & "And [Measure Type] = " & "'" & Me.CboMeasureType & "'"
?

Is there anything you don't know how to fix??? you rock :)

Is there anything you don't know how to fix???
Yes but the list is too long for here :D