Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Finding a record through an Access form

    Hi,

    Trying to figure out a process to find a record based on the record Id in an access form. My goal to have the user click find and it does not matter where the focus is, I want to prompt him for an order_id and populate the form based on that Id.

    I have this piece of code in the OnClick event but it is not working:

    docmd.FindRecord (inOrderId,acEntire,,acSearchAll,,acAll,,)

    Where InOrderId is the value entered from the input box by the user.

    Can you tell me where I went wrong?

    Thanks a lot
    Mo

  2. #2
    Join Date
    Jan 2003
    Posts
    46
    Assuming inOrderID is a declared variable and everything else is in order, the following adjustment will work:

    DoCmd.FindRecord FindWhat:=inOrderID, Match:=acStart

    Cheers,
    Zambezibill

Posting Permissions

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