booking rate as a field combo box doesnt show data

[lexygirl]

I have a field booking rate that is set up the following way

Booking Rate

combo box - value list

$200.00 Flight Experience
$175.00 Training Dual
$135.00 Training Solo etc

the first column is bound to the table

I have a parameter form which i enter instructor name, start date and stop date. Then i run a command button to view the form (query is control source)



In this query I have booking rate as i want to view it and then do calculations on it

gst: [booking rate] * .10
total value: [booking rate] + [gst]

when i run the command button to view the form it asks me to enter the booking rate though there is already a value in the table, when i don't enter a value and hit ok no data appears in all the fields on the form.

When i run the query i still get asked to enter the booking rate and when i dont and I enter the other three fields records are shown...

Why can i not see the booking rate and why don't my calucations work.

I have attached the objects in question in a database for viewing

Any help would be greatly appreciated

Thanks

Lia

[Toyman]

I have a field booking rate that is set up the following way

Booking Rate

combo box - value list

$200.00 Flight Experience
$175.00 Training Dual
$135.00 Training Solo etc

the first column is bound to the table

I have a parameter form which i enter instructor name, start date and stop date. Then i run a command button to view the form (query is control source)

In this query I have booking rate as i want to view it and then do calculations on it

gst: [booking rate] * .10
total value: [booking rate] + [gst]

when i run the command button to view the form it asks me to enter the booking rate though there is already a value in the table, when i don't enter a value and hit ok no data appears in all the fields on the form.

When i run the query i still get asked to enter the booking rate and when i dont and I enter the other three fields records are shown...

Why can i not see the booking rate and why don't my calucations work.

I have attached the objects in question in a database for viewing

Any help would be greatly appreciated

Thanks

Lia

The [booking rate] field in your table actually has two spaces between the two words. In your query, there is only one space between the two words. With that said, always try to avoid having spaces or characters (&%^#-) except underscores "_" between two words when naming db objects. You can run into problems such as in your case. Try using underscores to connect two word or using caps for the first letter in each words. Example: "BookingRate" or "Booking_Rate"

[lexygirl]

thanks so much for the reply, I'll put underscores in form now on.... should have realised it would be something like that.

My query now works on its own, but when i call the form that the query runs off, no records are shown, yet the query shows records when it is run on its own.

Any thoughts

Thanks Lia

[lexygirl]

i worked it out i put data entry to no and my records showed on the form. Not sure why i had to do this but on all other forms i didn't have to change the data entry.

thanks
lia

[Toyman]

i worked it out i put data entry to no and my records showed on the form. Not sure why i had to do this but on all other forms i didn't have to change the data entry.

thanks
lia

When you form is set to data entry, it is just that; the form will be used for data entry and no records will be shown