Update Field in 1 form based on value entered in another form

K

kswan

I have scoured this discussion group and cannot find this answer. I am hoping
someone can help.
DB consists of
2 Tables
CJ Record
CG Record
1 Form created from all fields in CJ Record Table
1 Form created from query all fields in CG Record and 1 field from CJ Record
(job code)

When a new record is added to the CJ form I want the field job code to
update on the 2nd from which is called CG record.

I researched after update but couldn't get the new code to show up on the
form called CG record

Any help would be greatly appreciated
Kathy
 
Top