multiple subforms

[beppe005]

I have one form with 3 subforms in it (they are countinuous form) and the
previous one and is (supposed to be) syncronised with the next.

Masterform
subform01 (id01)
subform02 (id02)
subform03 (id03)

I created a tex box in Masterform called "clone_id02", it is unbound, in
"control source" I entered =[subform02 Subform].Form![id02].
In subform03 I did the following:
"link child field" id02
"link master field" clone_id02

I did the same procedure for linking subform 01 to subform 02 (a texbox in
masterform, etc...)

With some research I got the following tip which uses the the "on current"
property, I should type, at subform02 "on current" property the following:
"parent!clone_id02 = me!id02"

For a while it worked, but then i realised that the "iclone_id01 and 02"
where not updated as I entered my data in the subforms. I kept these unbound
text boxes visible for my tests in the form, and they where totally void!

Can anyone help me?

TIA

Bep

 

[Albert D. Kallal]

I would dump the use of that un-bound contorl (you don't need it).

Assuming thatsubform01 is the "master", and the other two are Childs?

To make the two child forms follow, you need to put the following code in
the 01 (master) subform "on current event"

Me.Parent.subform02.Requery
me.Parent.subform03.Requery

The above will make the other two child forms follow....

For the linkFiels in for 02 (child form)

Link Master: [subform01].[Form]!ID <- replace id with primeary key
Link Child ID_Master

For the linkFiels in for 03 (child form)

Link Master: [subform01].[Form]!ID <- replace id with primeary key
Link Child ID_Master

 

[beppe005]

I would dump the use of that un-bound contorl (you don't need it).

Assuming thatsubform01 is the "master", and the other two are Childs?

To make the two child forms follow, you need to put the following code in
the 01 (master) subform "on current event"

Me.Parent.subform02.Requery
me.Parent.subform03.Requery

The above will make the other two child forms follow....

For the linkFiels in for 02 (child form)

Link Master: [subform01].[Form]!ID <- replace id with primeary key
Link Child ID_Master

For the linkFiels in for 03 (child form)

Link Master: [subform01].[Form]!ID <- replace id with primeary key
Link Child ID_Master


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn

It worked, thank you!
Thank you
Beps