how to write dlookup whith three criateria

[hmho]

Ho w can I write dlookup in form with three criteria. here is my fields in the form.
1. ActDate Date
2. ActSerialNO Text
3. ActName Text
4. ActStatus Number
5. ActEndingNo Nember
What I like to add the form is another field that looks up the ActEndingNo where the ActDate, ActSerialNo from the table and current record is the same and where the ActStatus is the previous one or -1 and my table name is TblActData.

Thanks

 

[Galaxiom]

The conditions in the lookup can be extended by using AND or OR as required.
Otherwise the lookups can be nested as in using one lookup to find the conditions for the next.