Set Combo value based on another combo box

[liddlem]

Hi. I have a form that uses ONE of THREE possible combo boxes to find a record.

I am finding a record by typing/selecting either the
USER_ID (combo1) or
SURNAME (combo2) or
FIRSTNAME (Combo3)

My problem is that I dont know how to update the remaining 2 combo boxes with the relevant info.

If i do 3 searches using combo1 then combo2 and then combo3 - each combo retains the value that was used for its own search.
For the unsuspecting user, this could cause confusion as the value in each combo does not necessarily relate to the same record.

So...If i type '123' in the USER_ID combo, I would like the FIRSTNAME and SURNAME combos to reflect the correct information.

One potential problem with this is that if combo1 updates combo2 then will the 'after update' event for combo2 and combo3 be fired and thus create a type of 'circular reference' on my form.

Anybody got a suggestion as to how I could resolve this.
Thanks

 

[spikepl]

One potential problem with this is that if combo1 updates combo2 then will the 'after update' event for combo2 and combo3 be fired and thus create a type of 'circular reference' on my form.

Nope. AfterUpdate of a control does not fire when the value of the control is set programmatically.