I have 3 related tables in a back end database (Access 2003). Each booking can have several members. A member can also have more than one bookings. So have a members table, booking table, and member_booking table.
The front end is copied to each user's desktop. Several users use a data entry form to add new bookings.
The booking form is data entry but has a sub-form to enable them to add multiple members to the booking. The subform is based on a query which has fields from members and member_booking. The subform has a combo box so they can choose the members to add. Also a button to open a form to add members to the database if they are not on the list.
It all works find but intermittently, some users open the form to add a new booking and the subform is just empty. No controls whatsoever. Then the next day when they open it, it opens fine.
I'm just so lost with this! Does anyone have any ideas of what I can check. Record locks is No locks on all forms.
Any help would be just great - thank you...![]()