About ID Carrying to the Subform

[notrino]

Hello,



I attached an application. When you push the button on F1 form, F2 form is opening. But at the same time, I want to ID1 value can be transfer to the ID2. Normaly I can do this necessary with this code; (F2 load event)

Me.ID2.DefaultValue = Forms.F1.ID1

But, I want to realize this application with macro or expression builder. I tried expression builder with this code but it is not working. Do you know why? Thanks.

[kd2017]

Have you tried using OpenArgs?

[notrino]

Hi kd2017,

I don't know, OpenArgs feature. I've reviewed it, but I can't relate to my need.

[June7]

These tables are set up with a 1-to-1 relationship. Why not have just 1 table?

WHERE condition is to open form filtered to an existing record. This does not pass value to form to create a new record.

I think OpenArgs is available only with VBA. If you prefer macro I think have to use TempVars.

Avoid code by using form/subform.