Update 2nd Table Using Changes in Corresponding Elements in 1st

[Ted]

i use a2k.

i have a table called 'Screening Log' which is the control source of a form
having the same name. i have a table called 'Patients on Follow-Up' which has
been linked in this mdb to another a2k mdb. when canges to certain controls
(i'll never get used to calling variables/data elements 'controls' but i
guess that's besides the point) are changed by the operator, i'd like the
controls they correspond with in the 'Patients on Follow-Up' table to reflect
the changes to the 'Screening Log' data generated by the operator. to further
confound things, the controls don't have the same names!

i'm acquainted with the the idea of generating an update query in the a2k
world having updated values in the *same* table as that where the source
controls reside, but this is pushing the envelope a bit 4 me. i like using
the (not sure of the name) 'interactive query design editor' to help generate
the SQL queries but i'm not thinking it's all that well suited to what i want
to to.

anybody run into a situation like this one?

 

[[MVP] S.Clark]

A variable is a memory storage area in VBA code. A control is an object
that the user interacts with on the form, or views on a report. Hope that
clears up that issue for you.

Thus I would've written it this way:

"i have a table called 'Screening Log' which is the control source of a form
having the same name. i have a table called 'Patients on Follow-Up' which
has
been linked in this mdb to another a2k mdb. when changes to certain
controls
are changed by the operator, i'd like the FIELDS they correspond with in the
'Patients on Follow-Up' table to reflect the changes to the 'Screening Log'
data generated by the operator. to further confound things, the controls
don't have the same names!"

Then, the answer could be, in the AfterUpdate of the certain controls, run
an update query, which is against the FIELDS in the table.

Also, don't use spaces in your table, field, form, or other object names.
They just cause trouble.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html