auto complete
- Thread starter Tech
- Start date
for renting out, its per hour * the car
each car has a different rent per hour (because they are different cars)
I have made a table with the prices and that is joined up to the "Cars" table...
but its getting that calculation on the bookings form....
if i add in the form detail, the prices table, and i run the form - nothing appears on the form at all! the components are there in design view, if i take out the prices table in the form detail, everything is fine...
each car has a different rent per hour (because they are different cars)
I have made a table with the prices and that is joined up to the "Cars" table...
but its getting that calculation on the bookings form....
if i add in the form detail, the prices table, and i run the form - nothing appears on the form at all! the components are there in design view, if i take out the prices table in the form detail, everything is fine...
You need to base your form on a query rather then on a table.
Create a bookings query.
Base your form on that query.
Add a listbox to select the car to be hired.
You could use DLookup to list the hire prices that come with that specific car.
Use either an unbound control to calculate hours * price or, better, add a column to your query with does the calculation.
You also would need to register your car as "Booked" in your table.
RV
Create a bookings query.
Base your form on that query.
Add a listbox to select the car to be hired.
You could use DLookup to list the hire prices that come with that specific car.
Use either an unbound control to calculate hours * price or, better, add a column to your query with does the calculation.
You also would need to register your car as "Booked" in your table.
RV
Similar threads
