Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FindFirst

Status
Not open for further replies.
livvie

livvie

Programmer
Apr 20, 2004
91
IE
FindFirst is only available for DAO what is the equivalent in ADO ?
 
Sort by date Sort by votes
Find will work but the "filter" method is more flexible. If the "find" is used a 2nd time on the recordset it will cause a requery which can be overhead on a large recordset, the filter will not.
 
Upvote 0 Downvote
all depends what you need to do with the recordset.

could you tell us what you want to achieve ?
 
Upvote 0 Downvote
I am trying to move from one record to the next on one tab by clicking a button on another.
 
Upvote 0 Downvote
I'm not sure I understand exactly what you mean.
For navigating through records on a bound form you can use Docmd.gotorecord (acNext)
 
Upvote 0 Downvote
The recs are listed on one form with other details on teh second (in tabs) the button needs to be on the details form which is the problem as it only displays the details of the record selected in the first tab.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top