date won't save 1

[zyphac]

I have a text box that is set for the current date. when I type data in my sub form it will not post the date in my table, all the other data I type in is saved. It may do it once, but that is all. any Ideas on this
zypha

 

[LMBag]

In your table check that the corresponding field is formated to a date.

If this is ok. Check that the table and form are bound properly, ie. the text boxes are all bound to the form, spelt right etc.

Try these, if all this is ok, get back to me.

LB

 

[zyphac]

The box is bound correctly, it is set for the current date.
It some times saves the date. All the other data is stored in the table. Even if I use a save record button it doesn't save. What a mystery? Hey thanks for your post.
zypha

 

[LMBag]

Ok Here's what to do this seemed to work for me.
The text box which is to contain the date set that formatted to the type of date you want, eg. short date.
Then on the form load procedure use the Now command instead of Date. This seemed to work for me.
So it should look something like

Private Sub Form_Load()
Me.Date = Now
End Sub

where Me.Date is the name of the textbox.

I hope this works for you.

LB

 

[zyphac]

Ah thank you, works wonderful!!! I appreciate your Help!!!
zypha