> Hi there
>
[quoted text clipped - 6 lines]
>
> Colin
Please include the relevant portion of any previous message in your
replies (as I have done with my previous reply and with this one).
This way, a reader doesn't have to search out the previous message.
You may remember all of the previous messages in regards to your
question, but I doubt that others will.
Substitute your actual combo field name for ComboName and substitute
the actual name of the field used as the criteria field in the table
for [SomeFieldInTable].
The code I gave you assumes the datatype of the[SomeFieldInTable] is
Number, and the bound column of ComboName is also a number value.
Different datatypes require a different syntax.
Look up, in VBA help,
Where Clause
as well as
Restrict data to a subset of records
for more information.

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail