Combo Box Record Selector

[jereece]

I have a form with several ways to navigate records.

One is a combo box record selector. In the combo box is a Work Order number and a description. The row source for the combo box is SELECT [SA AND EV].[w/o and task], [SA AND EV].WO_TSK_DESCRIPTION FROM [SA AND EV];

Another is a simple forward, backward, first, last and new buttons.

My problem is when I use the combo box record selector, then navigate any other way, the Work Order & Descripton in the combo box do not change to the new record. So the combo box does not follow the record information as it changes.

Does anyone know how to make this happen. I know it's possible because I have seen it before.

Thanks for your help.

Jim

 

[casey]

You could add a procedure in the form's OnCurrent Event that sets your combobox = to another field on your form. Do you have another field on your form that the comobox could be set to?

 

[jereece]

I don't see an OnCurrent Event. I do have an event procedure for AfterUpdate. It reads as follows:

Private Sub Combo74_AfterUpdate()
' Find the record that matches the control.

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[w/o and task] = '" & Me![Combo74] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub


I want this combo box to track with the the filed "w/o and task" as records are changed.

Thanks again for your help.