Update Field based on form value

[Auto]

hi all,

i am having a table with few columns, like CustomerID, SalesTotal, DateOrder, DateDue
then i am having a form for that table, and user picks a date now, i want that DateDue should be 30 Days after DateOrder, somehow i can get that done.

i tried making an after update on DateOrder and i placed this expression DateDue=DateOrder+30 and it dont show up anything
can anyone help please?

[lfpm062010]

Are DateOrder and DateDue defined as Date/Time type?

If not, need to convert the date string using "CDate" or some date function to convert to date/time type to do add.

Alternatively, function "DateAdd" will work as well.

[Auto]

thanks ifpm062010 for yr reply
answer on DateTime type is yes, they are both Date type
in regards to DateAdd, i tried that one too, but i cant get it work

[lfpm062010]

I created a simple table like you suggested and create a form using the form wizard based on that table.

Then I edited the "AfterUpdate" event on "DateOrder" textbox.
Private Sub DateOrder_AfterUpdate()
DateDue = DateOrder + 30
End Sub

Then I tested the form. It worked like it should.

The DateAdd will look like.
Private Sub DateOrder_AfterUpdate()
DateDue = DateAdd("d", DateOrder, 30)
End Sub

If you still have problem, can you post your code and/or your db.

[Auto]

brilliant, thanks
that works, i placed it in default value, should be in AfterUpdate
like this
Then I edited the "AfterUpdate" event on "DateOrder" textbox.
Private Sub DateOrder_AfterUpdate()
DateDue = DateOrder + 30
End Sub