combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a combo box to find records in a form. I works nicely but when I
arrow over to another record the combo box does not change. How can I ge the
combo box and the data in form to be aligned?

Moses
 
well, without know ing the rowsource of your combo or the names of your
controls, I'll assume that the bound column of the combo is also the PK of
your main form. So, try using the On Current event procedure of your main
form:

Private Sub Form_Current()
Me.YourCombo = Me.MyPKField
End Sub

replace "YourCombo" and "MyPKField with your control names.

HTH,
Brian
 
Great thank you that worked

Brian Bastl said:
well, without know ing the rowsource of your combo or the names of your
controls, I'll assume that the bound column of the combo is also the PK of
your main form. So, try using the On Current event procedure of your main
form:

Private Sub Form_Current()
Me.YourCombo = Me.MyPKField
End Sub

replace "YourCombo" and "MyPKField with your control names.

HTH,
Brian
Click to expand...
 
Back
Top