Update ComboBox when clicking next record

[MrDummy]

Hello,

I have a form containing a ComboBox. When a value is seletected the record is selected and all the information on the form is updated. If I add a Button (via the wizard) and select "Next Record" all the information on the form is updated however the ComboBox is not updated to that next value. How do I overcome this issue?

[Gina Maylone]

Hi!

What is the data source of your combo box?

Gina

[Missinglinq]

When you say

"When a value is seletected the record is selected and all the information on the form is updated"

do you really mean that an existing Record is retrieved?

When you say

"...all the information on the form is updated..."

it means that the info on the Record is changed and then saved.

Linq ;0)>

[MrDummy]

The record is retrieved from a table when a selection is made in the comboBox. But when I want to retrieve the info from the next record by using a button all the info from the next record is retrieved but the ComboBox remains unchanged.

There is no Control Source. If I make a selection here, the ComboBox can't be used. However there is a row source.

[Missinglinq]

Well, the Combobox is Unbound, as it should be, for this kind of thing, and so there is no way for it to know which Record is the Current Record.

The Value of an Unbound Control is the same for all Records. Why does it matter?

You could use code in the Form_Current event to either set the Combobox to Null, if it's having the previous selection displayed is distracting, or you could use the DLookUp function in the same event to set it to the appropriate Value for the Current Record.

Linq ;0)>

[MrDummy]

Many thanks. Thought there may be an easier solution. Used the DLookUp function

[Missinglinq]

Glad we could help!

Linq ;0)>