I'm using Access 2000 to make an application. There is a form with a combo box and a text box. Combo box shows UserID and text box shows UserName of User table. My idea is when I change UserID combo box, text box will change automatically. How can I do? Please help me.
or place soem code behind the relevant event(s) for the combo box, if you have already set the control source assuming you are using bound controls
choosing the appropriate event can often be a bit of a problem, especially for combo/list boxes.
on click.. certainly.. where the users has selected a row from the list box
on change... maybe(but I don't think its appropriate for you
on lost focus.. maybe
you may need to do a "bit of both", note that changes have been made in the on change event, and then handle those changes in the on lost focus event. You wouldn't want to reassign the value if the user merely temporarily visited the combo box, and left.. that would happen if the were just visiting. you only want to assign the value when its changed.