View Full Version : Validation Problem


Sam Summers
04-09-2003, 06:09 PM
Hi

I have a table (Equipment) that has a field (TestDate). I had set the validation rule for this field and the field on the form associated to this table to - Not >Now Or Is Null.
I decided to remove this rule but when I fill enter data into this form I get the Validation message 'Date cannot be in the future' even though I have deleted this ability from both the table field and the form settings.

Any ideas anyone.

Thanks in advance

Sam

Pat Hartman
04-10-2003, 10:51 AM
I have not run into this problem but it may be that you need to force the form to refresh its fields collection. Delete the recordsource of the form, save the form, and re-add the recordsource.