Tabbing through a form

H

Hanksor

I have a form that has an unbound combo box that has employees names in it
bound to the employee id. It pulls up the associated information into the
form just fine. The issue here is when the input person tabs all the way
through the record back to the combo box, the information changes to the
values of the next record but not the name in the combo box. I have two
questions;
1. Is there a way to stop them from tabbing through to the next record?

OR
2. Is there a way to pull up the employee name associated with the next
record into the combo box when the form is tabbed through?

I hope this is clear enough. Any help will be appreciated.
 
S

Steve Schapel

Hanksor,

I think it will serve your purpose to set the Cycle property of the form
to 'Current Record'.

However, if you want to allow moving through to the next record, it is
possible to do that too. In any case, if I am using an unbound combobox
to locate a record on a form, I would normally clear the combobox
(Me.NameOfCombobox = Null) as soon as the record location is done. This
emphasises that the combobox is not a data control, but is used for a
navigation purpose, and helps to avoid confusion. But if you want the
employee to be shown in the combobox, and if you want to allow tabbing
to the next record, you could use code on the form's Current event to
set the value of the combobox to the employee id.
 
Top