Any Ideas

[lead 27]

Hi

I am trying to do something which im sure I can do but just cant get my head to get it started.

I am trying to create a button that when pressed will update a field in a table to todays date

Any ideas?

 

[boblarson]

In the button's click event -

Me!YourFieldName = Date

 

[lead 27]

Is it possible to do it if you are trying to change a field in a table that isnt linked to the form the button is on?

 

[lead 27]

I have tried:

tbl!lastdate1.lastcheck = Date

The table is last date 1 and the field is last check, but I get the error Run time error 424, object required

 

[boblarson]

Is it possible to do it if you are trying to change a field in a table that isnt linked to the form the button is on?

You would just create an update query for that one and then run the update query. The other code is good only if the form you have it on is bound to that table.