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.
"nichole" <gouthronichole[ at ]hotmail.com> wrote in message
news:1153963086.523920.267090[ at ]h48g2000cwc.googlegroups.com...
[Quoted Text] > 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
>
|