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