Capture initial value of text box

[Paul]

Not sure why I can't seem to get this to work, but here's what I'm trying to
do:

I have a text box, 'Actual_Due_Date', tied to a field in a table. In the
same table is a text box named 'Org_Due_Date'.

When the initial value is set in the 'Actual' field, I want to capture and
store it permanently in the 'Org' field.

I have two forms, a New Project form and an Edit Project form. My thought
was to just setup a simple macro in the New Project form in the 'Actual'
field that says After Update set the 'Org' field equal to the 'Actual' field.
This would allow the user to change the due date when they are initially
creating a new project and to store the final date they enter before the
submit/close the form.

Then, in the Edit Project form, the macro would not be included so when they
change the Actual Due Date value, the Org Due Date value would not change.

Make sense? Not sure why this isn't working for me! Any help is appreciated.

 

[Jeff Boyce]

Paul

"not working" covers a lot of ground... ?Got symptoms?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Not sure why I can't seem to get this to work, but here's what I'm trying to
do:

I have a text box, 'Actual_Due_Date', tied to a field in a table. In the
same table is a text box named 'Org_Due_Date'.

When the initial value is set in the 'Actual' field, I want to capture and
store it permanently in the 'Org' field.

I have two forms, a New Project form and an Edit Project form. My thought
was to just setup a simple macro in the New Project form in the 'Actual'
field that says After Update set the 'Org' field equal to the 'Actual' field.
This would allow the user to change the due date when they are initially
creating a new project and to store the final date they enter before the
submit/close the form.

Then, in the Edit Project form, the macro would not be included so when they
change the Actual Due Date value, the Org Due Date value would not change.

Make sense? Not sure why this isn't working for me! Any help is

appreciated.

 

[Paul]

Sorry...by not working, I mean there is no value being populated into the
'Org_Due_Date' after there is a change made or value entered into the
'Actual_Due_Date'.

 

[Jeff Boyce]

And the code you're using...?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/