473,386 Members | 1,712 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

select the data in the subform display on my main form text field

MS ACCESS I want to select subform data that data display on my main data text field.I can't able to edit the form.
Please help me
Jan 15 '13 #1
3 2429
Seth Schrock
2,965 Expert 2GB
It is possible to reference the subform control like

Expand|Select|Wrap|Line Numbers
  1. Me.subform_name.Form.subform_control
It may even be possible to drop the .Form in the middle, but I'm not positive of that.

You would then be able to make the control on your main form equal the control on your subform.
Expand|Select|Wrap|Line Numbers
  1. Me.main_form_control = Me.subform_name.Form.subform_control
Without more information about what exactly your are trying to do, I can't say where to put this code. There are too many options and each would be used in a different circumstance.
Jan 15 '13 #2
zmbd
5,501 Expert Mod 4TB
Mohamedbarkath:
Your question as worded really is very vague... I almost deleted it for lack of detail and clarity.

However, thru the magic of my super-secret-decoder-ring: It sounds like you need to refer to the parent form's control.

The solution for referring to parent form controls is quite simple; however, we normally require that you post your work first.

What doesn't make sense is your generic comment about not being able to edit the form(s)? I can only guess that you mean that what you've tried doesn't work with the implication that you'd like some help - hence the need to see your work. It helps us help you in that the Experts get a sense of how much you know; thus, how to approach the question.

Please read: Before Posting (VBA or SQL) Code then post your work.
Jan 15 '13 #3
zmbd
5,501 Expert Mod 4TB
Cross posted with Seth:

@Seth: You've taken a great leap of faith and your offered solutions are along the same path I would have taken; however, as you note, OP hasn't provided enough information. Rather than play 20 questions with OP let's await OP's reply for my request for information.
Jan 15 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a main form with a continuous subform. On the main form I have a text box that references a field on the subform. What I'd like it to do is show the value...
0
by: Ellen Manning | last post by:
I've got an A2K form with a subform based on a query. This query has a checkbox and an amount field and returns records if checkbox is checked. I Dsum the amount field and display on the main...
18
by: Darryl Kerkeslager | last post by:
I don't do much with subforms - in fact I've deliberately avoided them - but .... I have a tab control that will contain several subforms, each bound to a separate table, and each table/subform...
1
by: luv4nrt | last post by:
Hello all, I have a membership dB in which I have a form that updates data in 4 tables. One of the tables is bounded to a subform within the Main membership form. I am trying to link all four...
1
by: sjvandevoorde | last post by:
I need some help with a couple forms/test fields. Bare with me I have been out of the field for some time and only consider myself an intermediate user. The first one is a subfrom which lists...
3
by: virtualgreek | last post by:
Dear all, I have a scenario that is driving me nuts. (MS Access 2003) I have a form/subform (Continuous form) where it gets its data from tables Order and Order_Details. In the footer...
1
by: Elainie | last post by:
I have a main form and in it I have a datasheet subform filtered on surname, I would like the users to select a name in their list on the subform then the data moves up into the main form... Is...
4
theaybaras
by: theaybaras | last post by:
Hi everyone, You've all been such a huge help to me since joining, and I'd just like to take a second to let you know how much I appreciate it! That said, I have another supplication! ;) I have...
2
by: post | last post by:
Sorry that this is rather basic. But I have tried the various suggestions given in this group and cannot get them to work. I have a main form, for simplicity called "Main". On it are two...
2
by: lonelylonely | last post by:
how to display in new text field when i add option from drop down list?
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.