Update field in table b from form a

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

Guest

I'm new to Access and VBA. (I've been working with Pick/Universe forever.)
I'm about going nuts trying to figure out something that should be (and most
likely is) very simple.

I have a form that reads and writes data from/to a table (call it
mainTable). It also reads data from a 2nd table (call it secondTable). What
I can't figure out how to do is update an item in secondTable from a
calculation in the mainTableForm. Specifically, I would like to take a value
from secondTable, subtract a value from mainTable and write the new value
back on the same field in secondTable.

Suggestions?
 
Do the two tables have a field in common such that you could join them in a
query for the RecordSource of the form?
 
Back
Top