go to record in form with list

theinviter

Registered User.
Local time
Today, 05:59
Joined
Aug 14, 2014
Messages
273
Dear Guys,
need help

i have a form a need to go to record upon double click in list,
i tried below code but not going to record
as the record is combobox.

Code:
On Error GoTo errhandler:
n = 1 / 0 ' cause an error
'Move to the record selected in the control

With Me.[Combine Query].Form.RecordsetClone
    .FindFirst "[Combo88] = '" & Me.List104.Value & "'"
    If .NoMatch Then
        MsgBox "No Record Found!"
    Else
        Me.[Combine Query].Form.Bookmark = .Bookmark
    End If
End With

Exit Sub
errhandler:
' error handling code
Resume Next

Code Tags Added by UG
Please use Code Tags when posting VBA Code
Please read this for further information:-
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
Please feel free to Remove this Comment
 
Last edited by a moderator:
is the Combobox bound to a Field of a table, then use the ControlSource of the Combobox.
 
not clear what you are trying to do, but if combo88 is bound to a field, use the field name
 
Also cannot be bothered to use code tags. :mad:
 

Users who are viewing this thread

Back
Top Bottom