 |
| 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
|
|
|
|
May 31st, 2006, 08:13 AM
|
|
Authorized User
|
|
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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!
|
|
May 31st, 2006, 08:20 AM
|
|
Authorized User
|
|
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi,
You can add a text box on the main form and set the control source to =Forms!subfrmYourFormName.YourFieldName
D. Bartelt
|
|
May 31st, 2006, 08:29 AM
|
|
Authorized User
|
|
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Can you please say me how can I do it exactly
Subform: 9_PARADOSEIS
fIELD: DATE
|
|
May 31st, 2006, 08:40 AM
|
|
Authorized User
|
|
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
What is the complete name of your subform? Ie: subfrm9_PARADOSEIS or is the name just 9_PARADOSEIS?
D. Bartelt
|
|
May 31st, 2006, 09:17 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|
|
June 1st, 2006, 04:43 AM
|
|
Authorized User
|
|
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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
|
|
June 2nd, 2006, 07:05 AM
|
|
Authorized User
|
|
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
June 2nd, 2006, 11:57 AM
|
|
Authorized User
|
|
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
June 2nd, 2006, 12:05 PM
|
|
Authorized User
|
|
Join Date: Apr 2005
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
June 3rd, 2006, 12:34 AM
|
|
Authorized User
|
|
Join Date: Apr 2006
Posts: 46
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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!
|
|
|
