Synchronsation

[Birdy]

I've forgotten how to sychronise a combo box to display the same record as the main form when scrolling through the records. Does anyone know how to do this.

 

[Hayley Baxter]

I've emailed you some samples, hope these can be of some use to you.

Hayley

 

[Birdy]

I have had a look at these but they are not what I require. If a user scrolls through the records, I want the combo box to show the current record.

 

[DBL]

You'll need to put a requery on the OnCurrent event of the form

Me.comboboxname.requery

Then as you scroll through it will show you the appropriate selection for that record

 

[Fizzio]

I assume that you are using a combo to select a record and that it is unbound. If so, make sure that they are linked somehow ie both the form and combo contain the record ID then on the On Current event of the form,

On Current
me.cboName = me.txtRecordID
me.cboname.requery

HTH