P
Patrick
I have a field titled Reference # in 2 tables. I use 1 table to update the
other table. In the form I have a control source that is =Format([Date
Processed],"mmddyy") & [Table Letter]
What I need is the control source that was created using the format..... to
be put into the Reference # field in my table [Update Table]. I am not sure
if you can state Reference # = ...... or what.
I created the form from the [update table] and the control works to put the
reference # how I want it in the form and now I need it to carry over to the
[update table] so when I run my update query it updates the reference # field
in the [master table]
other table. In the form I have a control source that is =Format([Date
Processed],"mmddyy") & [Table Letter]
What I need is the control source that was created using the format..... to
be put into the Reference # field in my table [Update Table]. I am not sure
if you can state Reference # = ...... or what.
I created the form from the [update table] and the control works to put the
reference # how I want it in the form and now I need it to carry over to the
[update table] so when I run my update query it updates the reference # field
in the [master table]