Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek or locate a record.
Message
From
02/02/2001 17:13:57
 
 
To
02/02/2001 16:41:25
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00472006
Message ID:
00472022
Views:
25
>I am using VB6 and Access97. I am using the data control object to move though the records on the form.
>
>However, if an ID is passed into the form, how can I SEEK or LOCATE that record and display that record in the form?
>
>Thanks,
>
>Jerryt

Jerry,
Assuming you are using ADO, the equivalent of Locate would be the Find method of the rs object. To use seek the provider needs to support indices, which I believe the jet provider does. The method would be Seek on the recordset object.

You can check if Seek is supported by the provider with Supports(adSeek) method of the recordset object. See exact syntax and examples on the ADO help in MSDN.
Previous
Reply
Map
View

Click here to load this message in the networking platform