how to pass pk to subform

[ahmed.gomaa]

dear all,
i have a problem in my application ,

i need to pass pk in form 1 to FK in form 2

there are a relationship(1:n)

i need when i open form2 ,i finda relation ship in table 2

i need this urgently

regards

[RuralGuy]

Some suggestions:
http://www.baldyweb.com/Bookmark.htm
http://www.baldyweb.com/wherecondition.htm
http://www.baldyweb.com/OpenArgs.htm

[ahmed.gomaa]

i want to tell me in example because i am beginner in access and i hope example for that .

regrads

[RuralGuy]

All three of those links have examples.

[ahmed.gomaa]

thanks a lot ,

in the first form :

i write : DoCmd.OpenForm "MediaDescription_F", acNormal

in the second form

i not write any thing

so when i enter data in the first form (Media_F) and click on button that i write into it the code second form (MediaDescription_F) open but i am not find the pk that in enter in the first form

please help me

[RuralGuy]

Try using the second suggestion link example.

[ahmed.gomaa]

thanks for your attention

but my issue is how to pass value from first form to second form
and second form is sub form i can not enter data into it until complete data in first form

regards,

[RuralGuy]

So what happens when you use the WhereCondition argument to apply a filter to the second form?

[ahmed.gomaa]

i need insert pk in the second form to make a relationship between 2 forms but where condition apply a filter on opening second form
regards

[RuralGuy]

In that case use the 3rd example with OpenArgs.