Update Main form control value into Subform control

[hwong]

Hi Everyone,

I have a question about updating main form value into sub-form. The background is:

Main form:
ComboboxA (01-10)
SubformB
TextboxC

Sub-form (01 - 10):
TextboxD (Difference control name in 01-10, but standard, say 01remark, 02remark, 03remark etc...):



Depends on value selected in ComboboxA, one of the subform 01-10 will be called out. Here is my code:

With Child01
    If ComboboxA <> "" Then
        .SourceObject = ComboboxA
    Else
        .SourceObject = ""
    End If
End With

Since I do not set a fixed subform, I cannot set Textbox C = TextboxD.

Would anyone help on this problem?

Thanks in advance!

[June7]

Why are there multiple forms playing 'musical chairs' for the subform control?

Don't understand what TextboxC and TextboxD are for - PK/FK link?

The main form is bound? Maybe set the Master/Child links properties?

[hwong]

Thanks for your reply!

The reason for playing "musical chair" is reducing time for searching the right form / table to update (what I want). Also, it reduces the size of main form not to show 10 forms altogether!

Sorry that I don't know the meaning of PK/FK links. My idea, is to update a textbox control on main form and to update the same content to another textbox control on a subform at the same time. My difficulty is that my subform source object is not fixed......so I cannot set Forms!mainform.textboxA = Forms!subform.textboxB.

Any methods? Please help. Thanks in advance again!

[June7]

PK = Primary Key
FK = Foreign Key

Once you change the subform SourceObject property, set the Master/Child links properties.

Actually never tried a dynamic subform so not quite sure that will work but seems reasonable.

[hwong]

Thanks June7. However, I have already linked another field. For better understanding, I have attached my database. I just want to copy the remark from "FormSummaryTable" to TableA ~ D when a record is added.

It frustrates me a lot. It seems Access is quite useless.

[orange]

To help us understand your database and frustration could tell us what the database is about?
What is the Business it supports? Can you tell us about your tables and relationships?

I think a lot of your frustration is related to this

Sorry that I don't know the meaning of PK/FK links.

.
For your own benefit and to reduce your frustration, I recommend you do some research and some practice exercises on
database design and Normalization. There is a design component that is often overlooked, or not recognized by new users of database software such as Access. Consider the analogy of building a house, proper use of hammers, saws and equipment is import, but I think you would agree that a plan or blueprint; even an artist's conception of the house is key.

So here are some links that should help with the design and concepts.
http://forums.aspfree.com/attachment...2&d=1201055452
http://www.rogersaccesslibrary.com/T...lationship.zip

The sooner you learn Normalization and the meaning of PK/FK, the sooner you reduce the frustration level.
Then your frustration will be with naming conventions and statement syntax. But that's down the road.

Good luck.

[hwong]

Thanks Orange.

I know there is a duplication in "Remark" data, but it is "straight forward" to me to store this value in two data table. I think Access could do it easily, like Excel copy and paste. That's why I am frustrated. Hmm......if no possible way to solve my question, I will try other ways.

Thanks June7 and Orange.

[June7]

It is possible to copy value in multiple tables but I am totally baffled that you consider this a benefit in your db design. There can be justification for duplication such as when prices are subject to change over time and is necessary that the prices associated with existing records are not altered. But to duplicate remark makes no sense to me.

I cannot review your db until after Feb 22. If you still need assistance after then submit a post.

[hwong]

I solved my problem. It is quite simple in fact.

Thanks all again.

[Rod]

Actually never tried a dynamic subform so not quite sure that will work but seems reasonable.

Think you can only change things like this at the form open event and not at the form load event.

It frustrates me a lot. It seems Access is quite useless.

There's a saying about bad workmen blaming their tools.

[orange]

I solved my problem. It is quite simple in fact.

Thanks all again.

Hwong, please post your solution to help anyone with similar problem.
thanks.