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

[shankar2]

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

[missinglinq]

You have inadvertently posted your question in the Articles section rather than in the Forum section of our site, so I have moved it across for you.

Welcome to TheScripts!

Linq ;0)>

[NeoPa]

If I understand you correctly, your solution should be found in a Form/Subform combination (The wizard should help you through this). I'm assuming a one-to-many relationship between tables A & B using the field you're referring to.