get result of the holidays on my form

[hamish mather]

on my form tblDebtor i have start date and end date in that selection


there are so many holidays(Count)...Now I need those holidays to apear
in my form eg 01/01/2012 and 16/01/2012.. I dont want the table to be on
my form... I hope this makes sense


I get count of holidays on my form

[June7]

You are allowing only two holidays to display by using textboxes to show the holiday dates. Will there always be only two holidays? If so, could try DMax and DMin to return the two values that fall within the date range.

Why is there a radio button?

[hamish mather]

I will put 5 or 6 txt box there,hidden and you an iff function not null to make the holiday
visable

the radio button will print the del slip for customer

[June7]

What is del slip?

Using textboxes is to retrieve and display varying set of up to 6 holiday dates will be difficult and is inefficient. I suggest a subform or a listbox.