listboxes...spelling real trouble...

[thetambarineman]

Hello all,

having a few probs with a feature id like to incorporate - i have a seperate search form in my project-from another form - call it an employer form... when the user searches for an employer- say Microsoft - the details come up in the list box.. i can work with that ok- and all i have to do is show the employer form and the record will be on the screen. However when the user searches for another employer-say- Acer - i cant get it so that when the user double-clicks on the list box-it doesnt go to the corresponding record in the access database...

Can anyone help me out??

Thanx in advance...

Paul

 

[VB400]

Can you publish the applicable part of the code?
Tarek

The more I learn, the more I need to learn!

 

[Snaggs]

If you're using a seek or a find method of the recordset, be sure that you move the record pointer back to the beginning of the recordset. So before you do your search you might do something like this:

rsEmployer.MoveFirst
rsEmployer.Seek &quot;<Criteria>&quot; Snaggs
tribesaddict@swbell.net
2 wire mesh butchering gloves:
1 5-finger, 1 3-finger, pair: $15

 

[GTO]

Function findtext1()
mycriteria = &quot;Employer=&quot; &amp; &quot;'&quot; &amp; List1 &amp; &quot;'&quot;
data1.Recordset.FindLast mycriteria ' Locate last occurrence.&quot;
End Function