dbTalk Databases Forums  

Update field in table b from form a

comp.database.ms-access comp.database.ms-access


Discuss Update field in table b from form a in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Martin
 
Posts: n/a

Default Update field in table b from form a - 09-30-2007 , 08:09 AM






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?

Bob



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.