This must be easy ... but I have been struggling a bit.
1. I own 4 hotels (pretend!). Hotel East, Hotel West, Hotel North, Hotel South
2. I analyse my hotel customers into sources such as, "Families", "Business", "Golf" etc.
3. At the end of each month I input the sales per source per hotel per week. E.g. Hotel East has 33 bookings for Families in the week ending December 31st.
4. QUESTION: See frmShowSpecificBookings. Firstly I choose a week at the top of the screen. How to I show ONLY those weeks bookings in the subform below (frmBookings).
PS: I am fairly sure I use a query in the subform that has Forms!frmShowSpecificWeek!
WeekID etc. However, I have been unable to implement this fully.