Home > IT Answers > Database > Getting DLookup to refer to a previous record in a filter
TRSJ
45 pts.
 Getting DLookup to refer to a previous record in a filter
DLookup, Microsoft Access
I am trying to use DlookUp to get field values from a previous recrod wher the records have been filtered.

 

I have found the code below but it refers to ID-1, rather the actual ID that may be the previous record resulting from the filter.

=DLookUp("[MyField]","MyTable","[ID]=Forms![MyForm]![ID]-1")

Any suggestions?

Thank you.



Software/Hardware used:
MS Access
ASKED: February 6, 2010  9:52 AM
UPDATED: February 8, 2010  1:47 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _