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.