Dear reader,



With a combobox I can go to a selected record picked in the pull down list.



And in the same time the record navigation field shows the selected record
number from the selection.



In case I go to another record by clicking the next record button the
combobox field will not by updated with the current record.



Is there any VBA code for updating the combobox field. This code is required
under the "On click" of the next record button but I do not know what to
specify.



Thanks for any help.

Kind regards,

Simon van Beek

"Simon" <S.v.Beek@HCCnet.nl> wrote in
news:43d24e6d$0$32762$e4fe514c@dreader25.news.xs4a ll.nl:
[color=blue]
> Dear reader,
> With a combobox I can go to a selected record picked in the
> pull down list.
> And in the same time the record navigation field shows the
> selected record number from the selection.
>
> In case I go to another record by clicking the next record
> button the combobox field will not by updated with the current
> record.
> Is there any VBA code for updating the combobox field. This
> code is required under the "On click" of the next record
> button but I do not know what to specify.[/color]

me.combobox.value = me!primaryKey (replace combobox with the
name of your box, and replace primaryKey with the name of the
field that is your combo box's displayed column.

It is better to put this in the .OnCurrent event of the form.
This will keep the combo box syncronized no matter what method
of navigation is used

--
Bob Quintal

PA is y I've altered my email address.