master and child link problem

[icemonster]

ok, i seem to have a problem.

i have done this many times with other forms and somehow for some reason this one is not working, here's the deal.

i have a main form and want the primary key of that form to link to my subform as a foreign key in that table, yet somehow, everytime i create a new record, let's say, the primary key is 4, so it should also be 4 on the subform, somehow keeps creating the value for that field as 1.

is there anything that i missed suddenly?

 

[icemonster]

lol i found the problem

 

[RuralGuy]

Would you care to share your solution with others that read this forum?

 

[icemonster]

Nothing special really. It was an error on my part. Sorry. I copy pasted the child field and somehow the controls got screwed up. So I was getting the FK from another control instead of the one that I want.

 

[RuralGuy]

Thanks for the update.