Access Developer Network

Global module Upload Images Link
Michelle Maughan
5 months ago

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.

Michelle Maughan
5 months ago

Adam Schwanz
5 months ago

You can e-mail me at to discuss needs and cost

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Developer Network Comments

Subscribe to Access Developer Network
Get notifications when this page is updated