Combo Drop Down

[Ishiguru]

Hi All,

I have a problem, that I can't seem to solve, and I wonder if any of you can help me.

What I have is a form that has a combo box on it, along with 2 text boxes. (date from and date to)

When this form is run, whichever option i choose from the combo box, is shown on the report.

However, On occasions I'd like to run the report for every option in the combo box, rather than a specific one.

Any ideas how I can do this ?

Thanks.

 

[mjdavie]

Try this link.
This method worked for me
www.mvps.org/access/forms/frm0043.htm

 

[Ishiguru]

Thanks for that.

I have done exactly as the article says, and now I do have (all) at the top of my list.

However my report returns '#error' and no data, even though if I run it for one of the items in the combo box, it works fine.

Have I done something wrong ?