Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: Dlookup by Record

    Is it possible to use a Dlookup to find a specific value, in a specific record.

    I know that I could use an ID field to do this simply; however, users will be adding and deleting from the list and the auto number would be not accurate over time. I would like use the record number the same way, as this would be more reliable.

    Rather than having: Dlookup("Name","tblTest","[ID] = 1)
    I would like: Dlookup("Name","tblTest",recordnumber = 1)

    Any thoughts? Thanks.
    Life's a bowl of punch, go ahead and spike it.

  2. #2
    Join Date
    May 2002
    Somehow I feel that you right in assuming the autonumber is the same as the record number is going to be a bad thing.

    You could do this in DAO instead taking a recordsetclone and seek-ing on the ID number.

Posting Permissions

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