Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 31st, 2006, 08:13 AM
Authorized User
 
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default Bring a field to a form!

Hi, again
I have a problem!

There is a subform into a form. I want now to take one field from the subform and take it to the main form (so that there will be two same fields in the form, one to main and one to subform!Moreover, when I'm changing the data to the field of subform automatically to change in the main form!
to be specific I want to see the data of this field twice!

 
Old May 31st, 2006, 08:20 AM
Authorized User
 
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

You can add a text box on the main form and set the control source to =Forms!subfrmYourFormName.YourFieldName

D. Bartelt
 
Old May 31st, 2006, 08:29 AM
Authorized User
 
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default

Can you please say me how can I do it exactly
Subform: 9_PARADOSEIS
fIELD: DATE



 
Old May 31st, 2006, 08:40 AM
Authorized User
 
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What is the complete name of your subform? Ie: subfrm9_PARADOSEIS or is the name just 9_PARADOSEIS?


D. Bartelt
 
Old May 31st, 2006, 09:17 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Create two fields, set the data source to be the same, when the set the AfterUpdate event on each field to requery the form containing the other field not being updated.

 
Old June 1st, 2006, 04:43 AM
Authorized User
 
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default

The name of main form is 2_ERGA, and subform 9_PARADOSEIS (not subfrm9_PARADOSEIS.
I tried =Forms!9_PARADOSEIS.DATE but doesn't show me anything.

Thank you very much

Vision G

 
Old June 2nd, 2006, 07:05 AM
Authorized User
 
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Do you need to enter data on only the subform and view it only on the main form? Or do you need to be able to enter the data in either field?

D. Bartelt
 
Old June 2nd, 2006, 11:57 AM
Authorized User
 
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this.

=[9_PARADOSEIS].[Form]![DATE]

Use [DATE] only if that is the text boxes’ name. If DATE is not the text box name replace DATE with the name of the text box. Ie: Text52

Hope this helps.


D. Bartelt
 
Old June 2nd, 2006, 12:05 PM
Authorized User
 
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I forgot to mention that the formula is to be placed as the control source of the text box on your main form. Whenever the DATE field is updated on the subform, the data will then show up on the main form.

D. Bartelt
 
Old June 3rd, 2006, 12:34 AM
Authorized User
 
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
Default

I have already done it, but it doesn't work and I don't know why!
I wrote =[9_PARADOSEIS].[Form]![DATE]
or =Forms![9_PARADOSEIS].[Form]![DATE]
but nothing I can't understand!
Whatever thank you for your advise!







Similar Threads
Thread Thread Starter Forum Replies Last Post
Requery a Form Field from another Form rocknrisk Access 3 September 16th, 2005 03:51 PM
Fireworks - Bring to Front crmpicco Dreamweaver (all versions) 1 February 12th, 2005 03:15 PM
bring to front dkr72 Excel VBA 1 December 2nd, 2004 05:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.