data from one field to fill in field in subform

[Bilal]

im doing this all as a bound form
my main form got a field named 'PersonID'.
my subform also got a field called 'PersonID'
the subform 'PersonID' populates however the mainform 'PersonID' does not.
i just need to write code, or maybe do something that will copy the number from subform and paste it in the mainform field, maybe at the click of my save button.

Any help? all help appreciated

 

[pr2-eugin]

What you are referring to is an Orphaned Child record.. Why would this exist? When the parent is deleted the child should (in theory) be deleted. Have you not implied Referential integrity in your relationship?

 

[Bilal]

What you are referring to is an Orphaned Child

It is definitely not orphaned, ive enforced referential integrity strictly, the fieldis meant to be there and is no mistake.
the main reason its there is that when the save button is pressed the PersonID number on the mainform can be saved in a table, but at the moment when i press the save button all fields for both the mainform and subform get saved apart from the personID of mainform

 

[Mihail]

It is definitely not orphaned, ive enforced referential integrity strictly, the fieldis meant to be there and is no mistake.
the main reason its there is that when the save button is pressed the PersonID number on the mainform can be saved in a table, but at the moment when i press the save button all fields for both the mainform and subform get saved apart from the personID of mainform

Why yo need to press "Save" ? Access do a save any time when you change a record and exit (somehow) from that record

Do a try:
Create another subform by using SubForm wizard.
Is this working ?

 

[Bilal]

Create another subform by using SubForm wizard.
Is this working ?

nope not working

 

[pr2-eugin]

So is the PersonID is bound to the field?

 

[Bilal]

So is the PersonID is bound to the field?

PersonID master is bound to PersonID child. would a stripped down version of the DB help?

 

[Mihail]

would a stripped down version of the DB help

Yes .

 

[Bilal]

here it is, as you see the data will al go to the table once the save button is pressed so that's okay.
however after i fill out the main form and subform i have to put a matching number in the main form that corresponds with my subform, if not the data wont show when im going through the records