Have a look at the following demo database:
http://www.accessmvp.com/Arvin/Combo.zip
Even though is uses listboxes, it does exactly what you want and can use
either a list or a combo box for. This particular example actually drills
down to the record by haveing 1 listbox, fill a second list box, which then
fills the folrm. All the code and queries are there for you to copy.

Signature
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
> Hi All
>
[quoted text clipped - 26 lines]
>
> Colin
weircolin@googlemail.com - 11 Aug 2006 13:10 GMT
Arvin
Thanks for yuor reply. This is going to be really helpful.
Do you know if there is any way I could choose a month to find out
stats for that particular time?
Thanks
Colin
> Have a look at the following demo database:
>
[quoted text clipped - 41 lines]
> >
> > Colin
jborron - 11 Aug 2006 18:57 GMT
I have a simler issue. I have figured out how to make a criteria entry form
prompt on the opening of a report. I have entered the fromula in the
criteria field of my query, but when I select ok the criteria entered on the
form doesn't run my query. after my entry form hides the query asks for the
criteria again. Any ideas.
> Have a look at the following demo database:
>
[quoted text clipped - 34 lines]
> >
> > Colin