combo box to populate text box

[ExcelDummie]

i've added a combo box that looks up fields in my organisation table i want
the user to select an organisation from this box and the organisation ID
field to be filled in the Organisation id field in the form?

 

[smk23]

Excel:
Try using the selection in the comboBox to move to the correct record, then
display the ID for that record on your form:
http://www.mvps.org/access/forms/frm0005.htm

HTH