How To Write Vb Code For This?

[townguy]

Hi Guys/Experts..

Currenly i am having a testing application.:


Database coloums : ID, Createddate, TimesheetDate, TagDate
Form fields : Createddate(not visible, auto today date), Timesheetdate(need user input), tagDate(not visible, for later use), radioButton(user choose New or Add Record) option.

What i want is, when user fill up "TimesheetDate" in the form and if the the "timesheetDate" already exist in the database, than the system automatically store today's "CreatedDate" into the original record's "TagDate".

Looking for VB code something like:

If Me!Timesheetdate = [TimeSheetTable].[TimeSheetCoulum] AND Me!radioButton="AddRecord"
Than update [Timesheet].[TagDate] as Me!Createdate]

Included the created databse and the interface.
Kindly need all of you help to come up with such a code.
Thank you

[June7]

Cross post at http://forums.aspfree.com/microsoft-...tml#post919267