Results 1 to 4 of 4

Thread: using FIND then updating a form

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2002
    Posts
    15

    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

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    Shouldn't you be using FindFirst instead of MoveFirst?

  3. #3

    Thread Starter
    New Member
    Join Date
    Jan 2002
    Posts
    15

    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.

  4. #4
    Fanatic Member
    Join Date
    Aug 2001
    Location
    Connecticut
    Posts
    855
    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
  •  



Click Here to Expand Forum to Full Width