You have provided very little information about the overall table design and relationships.
If you need a value to change between the tables... normally that isn't a really a good thing to have the same information stored in multiple locations and you will need to think about the normalization of the the database if not the entire overall design.
However, if your talking about pulling related records between tables:
Normally, there is a parent/child relationship between the forms wherein as the information on the parent form changes, links cause the subform to change in sync.
you can also do this via vba using the update event
take a look at:
41.How to select Records in an Access Subform from a Combo Box
you also might be interested in
Discussion: Advantages of a Subform vs. Filtering