fill in from another table

[blackcat]

i am using two tables on one form, one table being a subform of the main
form. i need to be able to fill in a record on the subform from a record on
the main form. is this possible and if so could someone please tell me how
to do.

 

[Jerry Whittle]

There should only be one thing that is duplicated in both tables. That is the
Primary Key on the parent table and the Foriegn Key in the child table. If
you have a proper relationship between the two tables, Access should
automatically populate the FK field with matching data from the PK field for
any new records.

Other than that if you are putting the same data in both tables, you don't
have things properly normalized.

Precisely what are you trying to copy from the main form to the subform?

 

[blackcat]

i am filling in fields from the main table, and i need to copy from field
'callstatus' to field 'revstat' on the child table. the reason for this as
that users are not always filling the 'revstat' field in and it causes a
problem with searches etc, so i wanted to default it with whatever is entered
into the 'callstatus' field