Trying to create a booking database, containing a calandar form, first subform containing booking detail, and second subform containing a selectable list of equipment required for that booking.
I've managed to get the calandar control link to the first subform - containing event details - so now the records change depending what date you click on. However, dispite numerous attempts i'm unable to get the records in the second subform - a equipment dropdown list - to stay linked to the related record in the first subform.
After entering a record in the first subform, and selecting equipment in the second, when i select a different date, even if there are no records in the first subform, the same equipment for the last record entered remains listed. Any suggestions?
I've managed to get the calandar control link to the first subform - containing event details - so now the records change depending what date you click on. However, dispite numerous attempts i'm unable to get the records in the second subform - a equipment dropdown list - to stay linked to the related record in the first subform.
After entering a record in the first subform, and selecting equipment in the second, when i select a different date, even if there are no records in the first subform, the same equipment for the last record entered remains listed. Any suggestions?