issue number 2 with combining control fields

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

Guest

Now that the reference number is created how do I get the table updated from
the control that was created? I have a master table with a field named
Reference # and an update master table with a field named Reference #. I
have all the data in the master table and created the form from the update
master table. I have an update query to update the master table and would
like the Reference # control in the form, =Format(Date,"mmddyy") &
TableLetter, to show up in the update master table so that when I run my
update query I update the Reference # in the master table. In the update
query the field is titled Reference # and now we have the control in the form
changed from Reference # to =Format.....
 
Post the code or the methods you are using to set these values so we can see
what is happening...

Incidentally, you should not use symbols or spaces in your field or control
names.
ReferenceNo would be a standard way of representing what you need.

Steve
 
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.

Thank you
 
Back
Top