I have set up a parameter form which runs off a query and i enter the instructor name and a start and end date and then hit view records button which pulls up a form and I view all the records for the parameters i set.
One of my fields in my query is booking rate - I want this rate to show on my form so two calculations can be made
1: gst (booking rate * .10)
2: total amount (booking rate + gst)
Booking rate is set up as a field in the following way
combo box value list
$200.00 Flight Experience
$175.00 Training Dual Rate
$135.00 Training Solo Rate
The bound column is the 1st column being hte amount. When I pick the correct training rate the amount is then saved to the table.
When i hit the command button to view the form it asks me to enter the booking rate, though this value is already saved in the records I wish to view.
When i hit ok and don't enter a value the form appears with no data in booking rate
calculations in query
gst: ([booking rate] * .10)
total value: [booking rate] + [gst]
How would I get the value that is saved in the table to show on the form and not be asked to enter a booking rate in the parameter box
Any help is greatly appreciated
Thanks
Lia
One of my fields in my query is booking rate - I want this rate to show on my form so two calculations can be made
1: gst (booking rate * .10)
2: total amount (booking rate + gst)
Booking rate is set up as a field in the following way
combo box value list
$200.00 Flight Experience
$175.00 Training Dual Rate
$135.00 Training Solo Rate
The bound column is the 1st column being hte amount. When I pick the correct training rate the amount is then saved to the table.
When i hit the command button to view the form it asks me to enter the booking rate, though this value is already saved in the records I wish to view.
When i hit ok and don't enter a value the form appears with no data in booking rate
calculations in query
gst: ([booking rate] * .10)
total value: [booking rate] + [gst]
How would I get the value that is saved in the table to show on the form and not be asked to enter a booking rate in the parameter box
Any help is greatly appreciated
Thanks
Lia