Combo 'find record' synchronisation

[caferacer]

Hi All,

Back into Access after a number of years away so a bit rusty.

I have searched through the forum a bit, but nothing jumped out as a solution.

I have an unbound combo box on a form used to locate/find records. Works fine as per the wizard.

However, when a selection has been made using the combo, if I then move to another record using navigation buttons the combo still displays the initial selection made with the combo?

I came across this problem some years ago and looking back at other db’s I created, I just blanked the combo field using Me![ComboName] = Null.

However, I would like what is displayed in the combo to remain visible and synchronised with the current record on the form when moving records using navigation buttons?

Have played around with the code Me![ComboName] = Null into various event procedures to try and see if this solves or improves, but with no success.

Any ideas?

Apols, I’m sure this has been covered possibly several times already on the forum, so please just point me in the right direction if it has?


Thanks

CR.

 

[Trevor G]

Welcome to the Forum,

What you need to do is in the Form Event and Current is set the Combo value to the ID field then when you navigate from one record to the next it will update the combo.

Example below:

Private Sub Form_Current()
Me.Combo132.Value = ProjectID
Me.Combo134.Value = ProjectID

End Sub

 

[caferacer]

Simples!! thank you, thank you, thank you!!

 

[Trevor G]

Happy to help and thanks for the reply.