Copy value from other form

  • Thread starter Thread starter Stilla
  • Start date Start date
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
 
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



How about:

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

Does that work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top