So I put in the combobox, than found this code to move to the record that matches.
Code:
Private Sub cboName_AfterUpdate()
Code:
Dim varName As Integer
'Moves Record Selector to record in subform that corresponds to the 'selection in this combo box.
varName = Me.combo34.Column(0)
With Me.FeedListsubform.Form
.RecordsetClone.FindFirst "JobID = " & varName
If Not .RecordsetClone.NoMatch Then
.Bookmark = .RecordsetClone.Bookmark
End With
End Sun
But I am strangely getting a run time 6 overflow error? The source of the comno34 control is a number field in a table, so I have no idea what is throwing the overflow error??
Anyone thing of a cleaner way to do this.
Combo34 = source = job id of table the feeds are in.
FeedListsubform = subform with the feed data including JOBID