How to Use a Form to read/write data in a second table?

[Shankar Raman]

Hello All,

This is my first try at posting a query in this forum, your patience is
appreciated.
App Details:
Access 2000 on Win 2000, Slightly better than a Novice, comfortable with
various acess terminologies and usages.

Problem on Hand:
I have a form A which is based on table A exclusively.
I have a form B which is based on table A and B. Within Form B, you can
select, by using combo boxes, fields from table A, and the pertinent data
associated with that record is displayed on the form B. Once you have data
displayed, you are now entering data (still on form B) that are related to
Table B. Somewhere within all this is a field called sequence number (called
different in both tables). I want to be able to update the sequence number in
table A while I am working on form B (this is a must). Technically the field
sequence number in table A is only a placeholder because it serves very
little or no purpose within Table A for that record. It is exclusively used
for table B, but the darn thing is associated with table A records.

I am not sure how to code this in VB. I am not sure what commands to use
within VB to update fields in a different table other than the one you are
using.

Any help will be sincerely appreciated. If this writeup is confusing, I can
try and illustrate with actual field names.

Thank you

Shankar Raman

 

[scubadiver]

Can you be more explicit with what the database is for and say what the
fields names are (and whether they are primary or foreign keys)