IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Windows vX.X Forum / I'll have to dig through some code,
Post #121,152
by jbrabeck
10/14/03 8:28:25 AM
Reply
New I'll have to dig through some code,
Had the same problem, now to figure out how I fixed it...

But, I'll be off-line (Class in Iowa) for the rest of the week. If no answer, will dig it out on Monday. Good luck...
"All men are like grass, and all their glory is like the flowers of the field;
the grass withers and the flowers fall, but the word of the Lord stands forever."
1 Peter 1:24-25
Post #121,172
by jbrabeck
10/14/03 11:50:01 AM
Reply
New I checked my code
Quick and dirty method.

I added the keyfield to the subforms (hidden). Then on the After_Update field on the Master form, I have the following code (snip)

strNewKey = fldKey (form Master Form)
Hardware!fldKey = strNewKey
Positions!fldKey = strNewKey

I have two subforms, 1 called Hardware and the other called Positions. May not be elegant, but it works!

The reason, that I have found, that it is not working, is that there is no record to link to for the subforms. And yes, to the best of my knowledge, I have all the relationships set correctly along with all the linking.
"All men are like grass, and all their glory is like the flowers of the field;
the grass withers and the flowers fall, but the word of the Lord stands forever."
1 Peter 1:24-25
     Ugly Access/VB problem: subform not updating - (tangaroa) - (6) - Oct. 13, 2003, 06:43:35 PM EDT
         I'll have to dig through some code, - (jbrabeck) - (1) - Oct. 14, 2003, 08:28:25 AM EDT
             I checked my code - (jbrabeck) - Oct. 14, 2003, 11:50:01 AM EDT
         Tried "Dataset.Prev(); Dataset.Next();" ? - (CRConrad) - Oct. 14, 2003, 10:27:34 AM EDT
         Is/are the link subfields in the subform's dataset? - (scoenye) - Oct. 16, 2003, 05:50:11 AM EDT
         Update -- still not wor.. waitasec. Fixed! - (tangaroa) - (1) - Oct. 20, 2003, 12:26:23 PM EDT
             Shouldda asked... - (jbrabeck) - Oct. 20, 2003, 02:08:11 PM EDT

+++ATH
71 ms