Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    11

    Unanswered: Using Find Massage

    Hello guys

    What i am trying to do is use a find statement to bring up a recold if there is one.

    I have tried playing with docmd.FindRecord statement but, cant get it to work.

    What ive done is used this line of of code to get a string that i want to search for and this works fine

    Paynumber = [Forms]![NSTOverView]![Traineess].[Form]![Text46]

    any ideas???

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Using Find Massage

    Use it like that.
    Docmd.FindRecord paynumber,,TRUE,,TRUE

    make sure paynumber is a string.


    Originally posted by shanecox
    Hello guys

    What i am trying to do is use a find statement to bring up a recold if there is one.

    I have tried playing with docmd.FindRecord statement but, cant get it to work.

    What ive done is used this line of of code to get a string that i want to search for and this works fine

    Paynumber = [Forms]![NSTOverView]![Traineess].[Form]![Text46]

    any ideas???

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    Use the DLookUp function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •