Using a Combo Box to jump to a record

[Access_Novice]

The Combo Box I added using the wizard seems to operate independently to the rest of the data in some cases. When I select a name, it does jump to the record. This is ok so far.

However, if I jump to the last record, while that does occur, the value in the combo box does not automatically change accordingly to the last record. Instead it still retains the last value selected. How can I get it to show the correct value if I jump to the last record?

Also, I entered two new entries in my underlying table. When I jump to the last record, those two latest entries are not showing up in the form. Why not? I refreshed the table, but that didn't help.

See the attached word file for a screen shot.Access Forms 2.zip

[June7]

Is the combobox unbound? How is selecting name in the combobox causing the 'jump'? What is the code?

[Access_Novice]

The combo box is unbound. When I say jump, I mean, I select a value in the combo box, and the remaining fields on the form jump to the proper record which is what it is supposed to do. I do not have any code. I used the wizard when adding the combo box to jump to a specific record.

When I jump to the last record with the navigation buttons, the last value in the combo box still stays there. Not sure why?

[June7]

It stays because the combobox is unbound. It will hold selected value until another selected or form closes. If you want it to be empty then need code.

I expect you have macro code (not VBA) behind the combobox. I don't use macros, only VBA. However, I suppose the macro could be modified to empty the combobox after each 'jump'.