Update

[Dan]

Hello:

I have these fields:

Status & Close date

The status changes to Closed when I enter a date in close
date. My question is how do I update the close date JUST
for the current record, when I click a button which runs a
macro and sends an e-amil notification...

Thank you,

Dan

 

[Guest]

hi,
you might put some code in your email button
something like this:
UPDATE YourTable SET YourTable.Status = "Closed" ,
Yourtable.CloseDate = [forms]![yourform]![CloseDate];
Where YourTable.RecordID = [forms]![yourform]![RecordID];

 

[Dan]

The button runs a macro, no code...

-----Original Message-----
hi,
you might put some code in your email button
something like this:
UPDATE YourTable SET YourTable.Status = "Closed" ,
Yourtable.CloseDate = [forms]![yourform]![CloseDate];
Where YourTable.RecordID = [forms]![yourform]![RecordID];

-----Original Message-----
Hello:

I have these fields:

Status & Close date

The status changes to Closed when I enter a date in close
date. My question is how do I update the close date JUST
for the current record, when I click a button which runs a
macro and sends an e-amil notification...

Thank you,

Dan


.

.