Field (combo box value list) wont display in query and needs to be entered

lexygirl

New member
Local time
Today, 19:45
Joined
Jul 8, 2011
Messages
3
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
 
Lia,

I'm a bit confused by your post. Just a bit :)

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.
What button are you talking about here and where is this button?
 
Lia,

I'm a bit confused by your post. Just a bit :)

What button are you talking about here and where is this button?

think the answer is in the 1st line of the post, not sure.. " hit view records button which pulls up a form and I view all the records for the parameters i set."
 

Users who are viewing this thread

Back
Top Bottom