MS Access - Move to a Specific Record in a Form.

[nichole]

Right now I have a form that loads a recordset of employees and their
information. I want to be able to choose an employee from a combo box
on another form and then load that employee and their information on
the main form. BUT... I also want to be able to move through rest of
the recordset as well. I guess I just want to move to the specific
record chosen. I have tried the recordset clone option and it finds a
match but when the form loads the employees information I still always
end up with the first employee in the database and not the specific one
I chose.

any suggestions??? I don't know how this works?


gstrSS = Form_Switchboard.txtSearchSIN

Me.RecordsetClone.FindFirst "[SIN] = '" & gstrSS & "'"

If Not Form_Switchboard.Form.RecordsetClone.NoMatch Then
Me.Bookmark = Form_Switchboard.Form.RecordsetClone.Bookmark
End If

Nichole

 

[Al Camp]

Nichole,
On my website (below) I have a sample A97 and A2003 file called QuickFindCombo. It
shows how to navigate from record to record by choosing a value from a combo... using the
FindRecord method.
That should be what you want.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.