M Barton,

The actual issue was treating the numeric field as a text field, which is
what gave me the error.

so:
"[Section]=" & me.cboSection.Value

is what I ended up with.

Also, thanks for the code. I didn't know there was a If Not IsNull was an
arguement (new at vba!), which cleans up my code considerably. Many thanks
for your help

Kawg

--
Message posted via http://www.accessmonster.com