combo box/bound text box

[Dan]

i have a form where i have a drop down combo box to choose
a lenders name and also a bound text box for lender
number. the combo box works correctly when i change the
lender name it changes the lender number, and also when i
change lender numbers the data changes in my subform to
the correct bank. my problem is when i change the lender
number it doesnt change my drop down box lender name. is
there a way that when i change the lender number that it
will change the lender name

 

[Kelvin]

Set the record source for both combo boxes to the same field from your query
or table. That way, when one changes, they all change. You don't need to
store both the name and number, just pick 1. If you must store both pieces
of info you will need to add code in the afterupdate event of the the lender
number using dlookup to set the value of lender name.

Kelvin