I have an ADP with SQL backend which was converted from Access. I had a combo box that worked in Access but it is not working since I upsized to the adp. Here is the After Update from the combo box.
What needs to be changed for it to work in the ADP?
Private Sub Combo144_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[fld_JobNumber] = " & Str(Nz(Me![Combo144], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark