Copy value from other form

S

Stilla

Briefly: Form A being used as a "startup" form. Form B used as a data entry
form. Form A remains open while Form B is being used.

Question: Could I have one unbound field (say "Field1") on Form A, and have
this value show up as part of the header of Form B?

On form B, I tried entering the expression below in the control source
box...

=[Form A].forms![Field1]

.....but all I get is "#Name?"

Thanks in advance
 
D

Dirk Goldgar

Stilla said:
Briefly: Form A being used as a "startup" form. Form B used as a data
entry
form. Form A remains open while Form B is being used.

Question: Could I have one unbound field (say "Field1") on Form A, and
have
this value show up as part of the header of Form B?

On form B, I tried entering the expression below in the control source
box...

=[Form A].forms![Field1]

....but all I get is "#Name?"

Thanks in advance
Click to expand...



How about:

=[Forms]![Form A]![Field1]

Does that work?
 
Top