Do you have a text box on the Form to show DueDate? John

DLookup

sorry I am sorry I am still learning how to do this. I am so confused on how to do the dlookup if I sented more photos could you help wald me through it?

Can I get some help figuring out what I am doing wrong and how I can fix it?

I am assuming you have the required fields in your Query.
Your DLookup will look something like this (modify as needed).

DueDate = Nz(DLookup("DueDate", "TimeOfRentalProductQ", _
"CustomerID=" & CurrentCustomerCombo & " And ProductID=" & ProductID), Date)

DLookup
DLookup Multiple Criteria
NZ Function

I don't think I have my Query set up right would you be able to help me with it? I really appreciate all of your help. I am trying to get my database set up. so I can get my business stared

Where is DueDate?

the Duedate is out of the RentalProductT