Two autolookup fields

[JTH]

How would I be able to have two autolookup combo boxes on the same form one
for CustomerID and a second for customer AccountNumber, both retrieving the
same information to the same fields (customer address and location)? I am
using Access 2000. Thank you

 

[Ofer]

Add to the source of the combo the two fields for example
"Select CustomerID , address ,location From MyTable"

On the after update of the combo enter the code
me.location=me.CustomerIDcomboname.column(2)
me.address =me.CustomerIDcomboname.column(1)

the same with AccountNumber
beside the source will be
"Select AccountNumber , address ,location From MyTable"