Null Date 31-12-1899

[Orit]

This one appears to work. ( I have to wait until I get home to look as I don't have 2007 at work, but anyone else that has it is sure welcome to check it out and chime in).

Great! Thanks! I'll wait

 

[Orit]

Any one have answer for me?

 

[ByteMyzer]

Patience. Not everyone has A2007, so by posting an ACCDB file instead of an MDB file, you have effectively limited the number of Users who might be able to help you.

 

[Orit]

I need to publish the database on SharePoint 2007 and it's just synchronize with access 2007.

 

[ByteMyzer]

In that case, you will simply need to be patient until someone else who has A2007 can look at it.

 

[boblarson]

Okay, here's what's wrong...

1. Your DateDue field on the form was bound to AssignedTo and not to DateDue.

2. You do not want to use Int([Date]) in all of those places.

3. You also on your StartDate in the Tasks table want to use =Date() instead of Now() for the default.

See the attached database.

 

[Orit]

First thanks a lot about your trying to help!!

You right, now I can get the correct date - but...
still the field that I wnat to be automatic - not get the date after someone enter in the other field data.

Do you know why? all I want to do is the field B will get date in automaticly way after some one enter to filed A data...

 

[Orit]

I'm trying again, if someone know how to help me, I'll more then be gald

 

[boblarson]

not get the date after someone enter in the other field data.

Sometimes you gotta work within Access' limitations. If the date is entered in the form then on the AfterUpdate of the other control you could use

Me.Recalc