PC Review


Reply
Thread Tools Rate Thread

Copy value from other form

 
 
Stilla
Guest
Posts: n/a
 
      14th Jan 2008
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
 
Reply With Quote
 
 
 
 
Dirk Goldgar
Guest
Posts: n/a
 
      14th Jan 2008
"Stilla" <(E-Mail Removed)> wrote in message
news:8174520C-B0EE-41F4-8980-(E-Mail Removed)...
> 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?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a copy of a form and link the entire form to a new datasour forest8 Microsoft Access Forms 1 12th Dec 2009 03:13 AM
Task Form: Unlock/clone/copy first page, or where to get prebuiltcustom form? alexw Microsoft Outlook Form Programming 5 2nd Jul 2008 10:43 PM
Copy Identical Field Values from Form A to Form B? =?Utf-8?B?Um9iZXJ0IFQ=?= Microsoft Access Form Coding 14 23rd Aug 2006 02:21 PM
copy text entered in a form to other location on a form =?Utf-8?B?SHVza3lkdXRjaGJveQ==?= Microsoft Word Document Management 4 27th Jul 2005 12:32 AM
Copy form with subforms, change copy without changing original fo =?Utf-8?B?REpXRg==?= Microsoft Access Forms 1 24th Oct 2004 01:18 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:01 PM.