[mihaufo]

I am trying to built an application to display the availability of data from different tables in a form of calendar.I have a table A, B, C.Now, I will have to display data availability on a certain date.if A, B and C are available display the date in the calendar as Green.if only A is available, then display the date in Orange and like wise.Kindly assist.

[OBP]

Have you created the Calendar Form yet?
If not do you have an example of how you want it to look?

[mihaufo]

I have attached the xls file in which I tried to design the forms, Sheet 2 contains the canlendar form. Sheet1 has the tables and from the next forms.

[OBP]

I think that design may be a bit optimistic. Especially as various Months have a different number of days.
What does your table design look like?

[mihaufo]

The tables are described in the Sheet1 of the attached "tables and forms.xls".

[OBP]

OK, well you will need a table of dates to create your form from, the Activex Calendar that Access provides is very inflexible and can't do what you want.