Robert,

I would have said just use ListIndex and offset from that, but this line
confused me

but help on using a decent command line would help cause
afterupdate is awful as you do not click off the obect
when you select a value!!!

could you elaborate?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Robert Couchman" wrote in message
...
Hello all,

i currently have been trying to use a combobox, that when
a value is selected from the list, or a new piece of data
is typed in, it will look though column "AX" to find that
value, then display the coresponding data from "AY" in
different textboxes.

if anyone would like more info please just ask,

but help on using a decent command line would help cause
afterupdate is awful as you do not click off the obect
when you select a value!!!

thank you,

Robert Couchman