Open form to specific record, error 3070

[msleelee]

I have searched many other discussion, but none of those solutions have worked.
I created a search form that returns results in a list box. I would like to able able to db click the list box to open the Employee's File. However, the code from Bradly Web, even after modify for a string has not yet worked. I receive Error 3070 stating that EReID is not recognized as a valid field name or expression.

EReID is autonumber primary key
EmployeeRecord is the table I am attempting to open to the specified record
TestTest is a textbox holding the eID from the listbox

Below is the code

Dim rs As Object
Dim lngBookmark As String


'set a variable to the current record


lngBookmark = Me.TestTest


'open the new form
DoCmd.OpenForm "employeerecord"


'take it to the selected record
Set rs = Forms!employeerecord.RecordsetClone
rs.FindFirst "EReID = '" & lngBookmark & "'"




Forms!employeerecord.Bookmark = rs.Bookmark


Set rs = Nothing

Any help is apperciated

[pbaldy]

The error would imply that isn't a field in the form's record source. I'd confirm that first.

Bradly web?

[msleelee]

OMG, Thank you SO Very Much!!!! That worked. I changed the name to what it is in the record source instead of on the form & that worked so perfectly!!!! You are so very much appreciated & yes I so spelled that wrong.

[pbaldy]

Happy to help, and welcome to the site!