Dcount and form not updating.

[abodi]

I'm not entirely sure why, but i think the format function around the vdate 6 ,11 ,16 fixed it.



Thanks again for all your help June7. You are amazingly patient and a big help to many many people.

[June7]

The references to vdate textboxes should not be within quote marks and use # delimiter.

"Scheduling_Date=#" & [vDate1] "#")

However, I just noticed (or did we already go over this issue) your dates are shown in dd/mm/yyyy structure. Access expects dates to be in mm/dd/yyyy structure.

So, yes, converting to strings might be better as long as the date strings all have the same number of characters. This means using placeholder zeros - 01/01/2014