In addition to Allan's advice, to clarify, you say
What I was wondering is how to test these values (which are from an
open form with
combos with values selected)
which could be construed to mean that cboCostCentre, cboCentreCostDesc and cboCatDesc are on an open Form, but not the Form whose Immediate Window is being used! Are you testing this in the Immediate Window of the Form that actually contains the Comboboxes, or from a different Form?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007