Simple Access Questions

  • Thread starter Thread starter bogii
  • Start date Start date
B

bogii

I am using MS Access XP and I am building a database with forms. I have an
ID(That is a primary key) on different tables that should be linked to the
first table so when the user enters in the ID in the first table it should
show up in all the other tables. I have set a relationship with all my ID's
linked together by a 1 to 1. How would I allow the ID's to automatically
be added on in the different tables ?


I also have main form with tabs and in the tabs there are subforms of the
different tables where the user enters the data. And I would like to know
what code can I use in the properties section on when a user presses enter
for it to move to the next tab. For example from tab: Page 1 to tab: Page 2
?
 
Your application must create the records in the related tables. It is rather
unusual, but not unheard-of, to add the records even before populating them
with data. There are various methods to create new records before inserting
data, and various methods to create new records as data is inserted.

If I were going to create the records regardless of data content, I would
most probably use VBA code in the AfterUpdate event of the Form from which
the main table's record is entered to run Append Queries to add records to
the related tables.

If creating records when adding data, I would use a method appropriate to
the situation. One approach often used, is to have SubForm controls in which
are embedded Forms for data entry into the related tables.

Larry Linson
Microsoft Access MVP
 
Okay so lets say the user enters the id in sub form 1/table 1 then I want
the same id to show up in table 2/form 2. How would I accomplish something
like that ?
 
Back
Top