I have a simple VB.NET form that is bound to a sql data source. The form was generated by Visual Studio.

I have made one field invisible. I want to set this field to the current date before I save the new or updated record.

I cannot seem to get this to work. If I leave the field as visible it seems to work. I have tried placing the code that sets the form value before the endedit and during the rowchanging event. Neither seem to work.

What i am trying to perform is the equivalent function that Access would call a before update.

Any suggestions?

Thanks