Pat, yes, I will remember to post a new thread for different topics. Thank you.
Yes, one BE and many FEs. The Dlookups are searching the Mileage Table, Inspection table, Maintenance Table, and Reservation Table. That was the dilemma I was facing trying to Join 4 Tables in one query to be the one data source for a single form's controls. The DLookup returns a boolean addition of two check boxes being a -1 or 0 adding up to -1+(-1) = -2 for Available and -1+0 = -1 for Dispatched. I can experiment with calculated query fields to do the math if I can get the complex join of all four tables. Would this be the faster way to go? Thank you.