Carry a value in a cmbbox to next record

  • Thread starter Thread starter Steven M. Britton
  • Start date Start date
S

Steven M. Britton

I have a single form that is used for dataentry, as the
user is inputing the data they tab through the form when
get to the last txt box they tab to get to a new record.

What I want to do is keep the value from one cmb box and
carry it so that don't have to reenter the employeeID when
they are doing a second entry for that employee...

Thanks

-Steve
 
In the form's AfterUpdate eventhandler, put in code along
the lines of
If Me.NewRecord Then
yourComboBox.DefaultValue = yourComboBox.Value
End If

You will have to change YourComboBox to suit your form.

Hope This Helps
Gerald Stanley MCSD
 
This won't work, the yourComboBox.Value is the Value from
the Previous Record -
 
Back
Top