Replace field with system date 1

[tadiguma]

I'm new to MS-Access and Visual Basic
I've used Access 2000 and created entry forms and want to replace a date field with the system date when the user clicks the save command.

I've used the following code.

Dim MyDate as Date
MyDate = Date
Forms!frmPersonal!date_ent=MyDate

I get the following error:

Standard Treatment trial can't find the field 'Date' referred to in your expression.
Any help that will solve my problem will be appreciated

Thanks

Thomas

 

[ZmrAbdulla]

Try only a single line without any decalration

Forms!frmPersonal!date_ent=Date

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[RoyVidar]

You may have named something date somewhere, if you find something, then rename. In the mean time, try disambiguating, which might work

[tt]Forms!frmPersonal!date_ent = VBA.Date[/tt]

Roy-Vidar

 

[tadiguma]

Thanks ZMRAbdulla for your tip. I tried this but it didn't work.
Roy-Vidar's solution worked. Thanks for the tip