Two autolookup fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
Back
Top