Can someone please help me. I am a booking agent for hunting properties, different properties have different pricing for accommodation or camping. I think I need a public function to get 2 values from a closed table PropertyXAccomT. One is an ID from a combo box (PropertyXAccomID), the other is a currency value (Price). On my BookingF, I have a checkbox, and used an IIF Statement in a textbox, Accommodation if checked, camping if not. On the BookingF, I have a CostPerPerson and Num days. I dont know how to get the Price assigned to the accommodation type from the other closed table then multiply by the number of days on the BookingF. If someone can help, please let me know to discuss costs.