auto populate field

[Guest]

I have two fields, one is Rep Name which is a drop down list, the other is
Rep ID. I would like for the rep ID to auto populate depending on the rep
name that is chosen.

 

[Ken Snell \(MVP\)]

See this article on The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

 

[Guest]

should both fields be set up as a combo box? And where does the code go?

 

[Ken Snell \(MVP\)]

The article describes how to allow a user to make a selection in a combo box
and to have other information (from one of the combo box's other columns) be
displayed in a textbox. There is no code so long as the textbox is being
used for display only, and not for saving data to the form's underlying
table.