Problems linking the fields in two forms

[Kenji]

I created a command button on my form so that I can open up another form to
save space and make it look neater on my main form. The common field between
these two forms is the PO (Purchase Order) number but the subform that opens
up does not autopopulate that same number from the primary form - how can I
fix this?

 

[Allen Browne]

Could you explain how you open the secondary form (not subform)?

Macro? What action(s)?
Code? What lines?

 

[Kenji]

i just used the command button wizard to create it. I selected Form
Operations then Open Form and selected the secondary form. The primary form
and the secondary form both have a common field which is the PO number but I
can't get the secondary form to display that info.

 

[Allen Browne]

Can you post the code the wizard created for you?

Also tell us what data type the PO number field is.
When you open the table in design view, is it a Text fiel? Or a Number
field?