seeking in a data control DB

I am using VB 4 to make a front end for an Excel database.  The front end is read only and the user is allowed to scroll through the entries and search for particular fields.  I am using a data control and binding labels to the appropriate fields.  How can I allow the user to search for X in fieldY?
BoBAsked:
Who is Participating?
 
clifABBCommented:
Let's see...
Name of a dog in children's songs.  :)

I will assume I can resubmit for points.

If X is a numeric value:
Data1.Recordset.FindFirst "fieldY = X"
If X is a text value:
Data1.Recordset.FindFirst "fieldY = 'X'"

Change the RecordsetType on your Data Control from 0 - Table to 1 - Dynaset
0
 
clifABBCommented:
If X is a numeric value:
Data1.Recordset.FindFirst "fieldY = X"
If X is a text value:
Data1.Recordset.FindFirst "fieldY = 'X'"
0
 
BoBAuthor Commented:
This command gives me error 3251 "Feature not available."  Any other suggestions?

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
clifABBCommented:
Change the RecordsetType on your Data Control from 0 - Table to 1 - Dynaset
0
 
BoBAuthor Commented:
Bingo!
0
 
BoBAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.