multiple subforms

  • Thread starter Thread starter beppe005
  • Start date Start date
B

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
 
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 said:
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
Click to expand...

It worked, thank you!
Thank you
Beps
 
Back
Top