Linking fields in a table to automate a result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am creating a new database to help keep track of all our contracts.
I have a check box field (Yes/No) called "Follow Up", and a column next to
it called "Follow up Date", and I would like to automatic the "Follow Up
Date" column so that when the check box is clicked in the Follow Up column,
that it will automatically fill in the field in the "Follow Up Date" column
with today's date + 7 days.

Is this possible?
 
On the after update event of the check box you can write

Me.[Follow up Date] = DateAdd("d",7,Date())
 
Thanks Ofer,

This is for a form right? If so, I added your formula to the check box
column, but when I try to run it tells me the macro doesn't exist.....

I am very new at this and would love some guidance.

Ofer Cohen said:
On the after update event of the check box you can write

Me.[Follow up Date] = DateAdd("d",7,Date())


--
Good Luck
BS"D


ldalzell said:
Hi,

I am creating a new database to help keep track of all our contracts.
I have a check box field (Yes/No) called "Follow Up", and a column next to
it called "Follow up Date", and I would like to automatic the "Follow Up
Date" column so that when the check box is clicked in the Follow Up column,
that it will automatically fill in the field in the "Follow Up Date" column
with today's date + 7 days.

Is this possible?
Click to expand...
Click to expand...
 
You enter this code in the property line instead of the code section, and
this is why it's looking for a macro.
When you locate the cursor on the after update event you'll see on the right
a button with three dots, click on it and select code editor, insert this
code line to there.

--
Good Luck
BS"D


ldalzell said:
Thanks Ofer,

This is for a form right? If so, I added your formula to the check box
column, but when I try to run it tells me the macro doesn't exist.....

I am very new at this and would love some guidance.

Ofer Cohen said:
On the after update event of the check box you can write

Me.[Follow up Date] = DateAdd("d",7,Date())


--
Good Luck
BS"D


ldalzell said:
Hi,

I am creating a new database to help keep track of all our contracts.
I have a check box field (Yes/No) called "Follow Up", and a column next to
it called "Follow up Date", and I would like to automatic the "Follow Up
Date" column so that when the check box is clicked in the Follow Up column,
that it will automatically fill in the field in the "Follow Up Date" column
with today's date + 7 days.

Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
Thank you!

This works perfectly!

Ofer Cohen said:
You enter this code in the property line instead of the code section, and
this is why it's looking for a macro.
When you locate the cursor on the after update event you'll see on the right
a button with three dots, click on it and select code editor, insert this
code line to there.

--
Good Luck
BS"D


ldalzell said:
Thanks Ofer,

This is for a form right? If so, I added your formula to the check box
column, but when I try to run it tells me the macro doesn't exist.....

I am very new at this and would love some guidance.

Ofer Cohen said:
On the after update event of the check box you can write

Me.[Follow up Date] = DateAdd("d",7,Date())


--
Good Luck
BS"D


:

Hi,

I am creating a new database to help keep track of all our contracts.
I have a check box field (Yes/No) called "Follow Up", and a column next to
it called "Follow up Date", and I would like to automatic the "Follow Up
Date" column so that when the check box is clicked in the Follow Up column,
that it will automatically fill in the field in the "Follow Up Date" column
with today's date + 7 days.

Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top