Question Need some urgent help for a booking system

[mike2325]

Hi,

I am creating a vehicle booking system in Access 2007 and I need some help altering a prototype that I have made.

The current prototype of the system looks like this:




I would like it so that if the booking start date is changed in the field above, the list of periods (of time) will appear in the subform below for the specific date and will show if any vehicles have been booked due to the checkboxes being ticked or not on the specified date.

Thanks very much,
Mike

 

[ezfriend]

First thing comes to my mind would be to create a view (query) that display the information you need for that sub-form.

When user enter a date and LOST_FOCUS/Enter/Exit the field, modify the query def to something like this

e.g. SELECT * from vwVBook where BookDate >= #YOURDATE#

Then requery/refresh the sub form.