I have a report named Bonus Attendance Report with an unbound textbox named txtprorate and a bound field named AdjServiceDate.
The table name is BonusAmount with fields named Payment and ProDte.
I'm trying to search the table in the ProDte and find a match with the AdjServiceDate that will then list the Payment in the unbound textbox on the report.
I would also like to have a default amount of $1000.00 if no match is found. Is this possible?
Code:=DLookUp("Payment","BonusAmount","ProDte = '" & [Reports]![Bonus Attendance Report]![AdjServiceDate] & "'")