combo box coding

[Anonymous]

I'm using a combo box to select from a table.

I want the other fields within the form to 'line up' with the selection in
the table.

I cannot for the life of me remember what the coding was to do this.

Any help appreciated.

Dave

 

[Alvin]

In the "After Update" event for the combo box, you'll need
to write code to change the other fields based on the
new .Value in the combo box.

 

[Bruce M. Thompson]

I'm using a combo box to select from a table.

I want the other fields within the form to 'line up' with the selection in
the table.

I cannot for the life of me remember what the coding was to do this.

First, make sure that the combo box has an empty "control source" property (it
needs to be "unbound") so that you won't be changing the value of a field. See
the following page at The Access Web for code to make your form move to the
selected record:

Forms: Have the form move to the record selected in List/Combo box
http://www.mvps.org/access/forms/frm0005.htm