Data Entry Forms with joined tables

[Judy]

I am trying to create a data entry form the will take the
keyed record from one table and insert that value along
with the related name into the joined table. For example:
The data entry person should be able to enter "25" and
the name field should pop up "Smith", then the rest of
the informtion that is relevent to table 2 should be
entered. All of this information should then populate
table 2. I do not know VB, so I'm pretty much stuck using
the macro builder. Any help would be greatly appreciated.

 

[Treebeard]

I am trying to create a data entry form the will take the
keyed record from one table and insert that value along
with the related name into the joined table. For example:
The data entry person should be able to enter "25" and
the name field should pop up "Smith", then the rest of
the informtion that is relevent to table 2 should be
entered. All of this information should then populate
table 2. I do not know VB, so I'm pretty much stuck using
the macro builder. Any help would be greatly appreciated.

Not a problem Judy, you should not need any VBA. Just create a query that
joins the two tables (if you haven't done that already). Select the form
wizard to create a new form and select all the fields you require from the
query in the form. It will ask you how you want to view your data, select
"By Table 1" or whatever you are calling your first table.


Jack