Syncronizing a subform within a subform

[OC2]

Hi,

ok first ill try and explain what I have done.

I have a main form which consists of some updatable fields to existing records in my database.

To scroll through these current records I have a subform in continuous form format. Upon clicking the record selector located on the side of the table the information on the main table will syncronize with the info shown on the subform using this command on the subforms click()

DoCmd.GoToRecord acDataForm, "escalationlist", acGoTo, Me.CurrentRecord

now this works fine.

My problem is, when inserting the mainform/subform onto another form, the two are no longer syncronized.

does anyone know how to solve this problem.

thx

 

[jgoodman00]

Have you checked to see that the LinkMasterFields & LinkChildFields are set correctly? James Goodman
j.goodman00@btinternet.com

 

[OC2]

Its not a child/ master problem, its to do with the current record feature. It works when its just the main form/subform, but when implanted into another form, it will not work anymore. I need to know the code to get it working again

 

[fynder]

You need to properly reference the form/subform. When it has been inserted into another form, THAT form becomes the "Main" form. The former main form is now a subform of the new one and needs to be referenced as such. "Databases That Work The Way You Do!"

 

[OC2]

OK, I now know that using the DoCmd.GoToRecord function only works with a main form/subform. the main problem now is to get it to work with a subform within a subform.
Could someone pls help me out or at least point me in the right direction

thx

 

[OC2]

bump