update two tables with one combobox

  • Thread starter Thread starter mark r
  • Start date Start date
M

mark r

I am trying to get one combobox to update two different
fields in two different tables.........I know how to use
recordsource for the "first table" and am trying to figure
out code for the updating of the field in the second table.
 
Mark

Why? As in "what business need compels you to redundantly store the same
fact more than once"? I'm not asking this as a rhetorical question, but to
better understand your data/data model...
 
It is a long explanation, which both of us are not going
to weather 20 messages back and forth. In short, there are
dual tracking systems, one abbreviated and one detailed,
which the user has the choice of using only one, or else
both as a check and balance, one uses an abbreviated
version of the data and the other the full details.....

Look, this is a question, questions take time to type and
post.....You do not need to know "why" in order to answer
the question.

If you do not care to grace me with your also valuable
time, then please just don't answer the thread at all, and
let someone else who is in it to answer the technical
question for "the sake of the question".

I appreciate all your past [and hopefully future help] but
I just don't have the time for the banter. I know all
about redundancy and hope better meet your standards in my
next life.
 
A simple way of doing this avoiding using code is to set up a relationship
between the 2 identical fields in the 2 tables with referential integrity
enforced aand set to cascade updates.
 
Mark

I went out of my way to explain that knowing what you are trying to do helps
me better answer your "how" question. Sorry you took that as unnecessary
banter.

If you have both detail and summary needs, these could possibly still be met
with a single detail entry, but using a query to provide the "summary" view.
 
Back
Top