|
-
Jan 10th, 2002, 02:52 PM
#1
Thread Starter
New Member
using FIND then updating a form
I'm new so excuse my ignorance.
I'm using the FIND method to search a record set. The criteria for the find is a value selected from a dbcombo on a form. Once the
user has selected a value in the dbcombo I do the following
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.Find "airline_name = '" & DataCombo1 & "'"
I get to that record, or at least I seem to. I would then like to update a bunch of text boxes based on the new record position.
Text2.Text = Adodc1.Recordset("webid")
The problem is that at this point I seem to be still on the old record even though the find was successful. Does the find also
reposisiton you at that record found and if so should'nt the
fields in that record be available to populate form fields? Thanks
-
Jan 10th, 2002, 03:27 PM
#2
Shouldn't you be using FindFirst instead of MoveFirst?
-
Jan 10th, 2002, 03:31 PM
#3
Thread Starter
New Member
Findfirst
From some reading I did I thought that when you use the find
method, you must first move to the beginning of the recordset and then perform the find.
-
Jan 10th, 2002, 04:01 PM
#4
Fanatic Member
You're right about everything except:
the text property is not the default value of Datacombo.
Specify Datacombo1.Text
VB 6.0, Access, Sql server, Asp
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|