Error message in a date/time field

Question

I have 2 tables.... one is vendors... one vouchers --linked through vendor#

I have a form created from vendors that shows both the vendor info and the vouchers paid associated with the vendor.

Here is my problem.. I have a "date/time" field in the voucher table listed as "voucher date".

While in form view every time I try to enter a date in this field I get the following error.

"The value you entered isn't valid for this field"

I have tried entering the date directly into the field and to use the pop-up calendar  associated with the field.  Same error in both cases.

As an odd note... I can go directly into the voucher table (in datasheet view not linked to the vendors table) and enter into this particular field (both ways) without error message.

On a similar note... I just finished creating a similar situation with and employee/payroll join and it worked fine.

Any suggestions anyone?

Thanks

Answer 1

Open form in design view, right click, scroll to bottom, select Properties, select Data tab, copy the record source, paste the SQL in a query SQL View and try running it.

If it will not run the paste it in a post.

Answer 2

It is based off of the Vouchers table... Not a query.

Any suggestions would be awesome.

Answer 3

Hi Russell,

Is the record source for this form based off of a query?  If so, does the problem occur if you try and add the data in the query?  Also if it is based off of a query, can you post the SQL of that query so that we can take a look at it?

Best Regards,

Nathan O.

Microsoft Online Community Support