Calender

[djdx2]

So basically.....I want to create a Booking Calender....just like the attached picture from my excel file.


Ive created a form, filled it with formatting and text boxes, Record source for the form is my "Calender" table.

Now i was told to make 31 subforms to populate each day, and filter each subform to that particular day, but this creates 31 EXTRA forms in my database which i do NOT want!

I only want ONE table for entries and a field for the date, to match up with the corresponding text box(s).

I want to achieve this by on form load....
IF record WITH the corresponding date EXISTS......THEN populate that into text box.

What is the best way to achieve this???

Ive been trying to mess around with strSource / strDateField / OpenRecordset which im not 100% on, cuz i cant find any study material on this.

Any pointers?

[amrut]

I would suggest to use list boxes on form and use a single pop form to edit individual day's data. Use a suitable event say double click on a listbox to open the popup form filtered for that particular date. Requery that list box when this form closes to show updated values.
Does this makes sense ?