Combo Box (1 Viewer)

[vjmehra]

Hi,

I have a combo box in a form, which displays names of people based on their ID number, from a field called number. On my form I have the number field displayed in a seperate control to the drop down menu. Although this works fine, whenever I click on any field other than the combo box and scroll through the combo box doesn't change, so the data displayed is incorrect. If I change records (each person has a unique record) by using the combo box everything works fine. Is there any way to update the combo box when I scroll through the other fields?

 

[Jack Cowley]

If you created the combo box, using the Wizard, to find records then it is an unbound control. You can't use this control to both find a record and display it. I suggest you add the controls to the form that display the names and use the combo only as a means of selecting records.

hth,
Jack

 

[vjmehra]

I discovered a way of doing this, by using some simpel code in the oncurrent property of the form:

Me.[COMBO BOX NAME] = Me.[ID FIELD]
Me.[COMBO BOX NAME].Requery

 

[Jack Cowley]

Congratulations on solving your problem!

Jack