Record select using a combo box

  • Thread starter Thread starter MeSteve
  • Start date Start date
M

MeSteve

I have a form that uses a combo box to select the record displayed. When the
form is opened, the first record is displayed, but the combo box is empty.
Is there a way to populate the combo box to match the record displayed upon
opening the form?
 
In the form Load event:

Me.MyCombo = Me.SomeControl

SomeControl would be the control bound to the field you want to match on.
 
Works great. What event would fire on record change, such as selecting a new
record via scroll wheel?
 
The Form Current event fires on each record change including the first. If
you want to sync your combo on every record, take it out of the Load event
and move it to the Current event.
 
Back
Top