Update

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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];
 
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


.
Click to expand...
.
Click to expand...
 
Back
Top