Can't Tie a Field In A Subform To a Field In Main Form (worked in 2003, not in 2007)

[justinhampton81]

Summary:


Need to tie a field value (sjobID) in a subform to a field value (jobID) in a main form in Access 2007

Parent Form: "Form1"
Parent Form field: "jobID"
Sub Form: "sfrm_Container"
Sub Form field: "sjobID"

Previously used "=[Forms]![Form1]![jobID]" in the sjobID in Access 2003

Question
I have a main form called "Form1" and a subform called "sfrm_Container" which holds 2 nested subforms. The form (Form1) and subform (sfrm_Container) are linked by jobID and sjobID.

I need the field called "sjobID" in "sfrm_Container" and have the value be equal to the "jobID" in "Form1". In Access 2003, I was able to do this using this formula: =[Forms]![Form1]![jobID]. However, this no longer works in 2007.

Any suggestions? Does this need to be done through the code builder now in the main form's onCurrent? Any help would be much appreciated.




sjobID - is the name of the field that is being pointed to.

[weekend00]

open the properties window of the subform control, on page "Data", setup "Link Child Felds" to sjobid and "Link Master Fields" to Jobid

[justinhampton81]

open the properties window of the subform control, on page "Data", setup "Link Child Felds" to sjobid and "Link Master Fields" to Jobid

That relationship does already exist.

[weekend00]

so it show work. what is wrong? does the subform not show the right record?

[justinhampton81]

so it show work. what is wrong? does the subform not show the right record?

Thats what I thought. When you cycle through the main form however, the subform will not update along with the record being displayed in the main form.

This is frustrating since it worked fine in 03, but our company updated to 07 and there is no option to keep 03.

[weekend00]

I don't use 2007.

[justinhampton81]

I don't use 2007.

lucky..... thanks for your help though. I've gone through and checked all of the formulas in the forms as well, and those don't appear to be related to the jobIDs either. thought it might be something there, but no luck.

[weekend00]

may you create a new form and new sub form, to see if there is surprise?

[justinhampton81]

may you create a new form and new sub form, to see if there is surprise?

Thanks - when I tried that, it didn't work. But, I tried it again as you suggested, but it still didn't work.

What I did notice though was that 2007 defaulted the new subform to having a record source from one of my tables, rather than leaving it unbound. After tinkering with that, and resetting the table source back to the default, it appears that has resolved it.

No idea why thats necessary now, as I believe that the code would have taken care of this. Either way - thanks for your assist. Helping me talk that through led to the solution.

Thanks!

[weekend00]

Merry Christmas.