Passing values from Child to parent (1 Viewer)

[Super Suarez]

Hi

I have a variable tempnum on a subform which I want to pass into a textbox on the main parent form. I cant seem to get it right. Here's my code

Me.Parent.Parent![List num].Value = tempnum

Hope you can help

 

[pr2-eugin]

Try

Me.Parent!
[List num] = tempnum

 

[Super Suarez]

Thanks but no that's not working.

 

[jdraw]

What exactly does "not working" mean?

You could do some debugging.

 Debug.print Me.Parent![List num]
 Debug.print "Tempnum  " & tempnum
.....
Me.Parent![List num] = tempnum [COLOR="Green"]'your original line[/COLOR]
 Debug.print Me.Parent![List num]

 

[Super Suarez]

It's not writing a value to my [List num] textbox on my main form.

I've tried msgbox() instead of debug.print but again nothing except for msgbox("Tempnum " & tempnum) where it does output tempnum.

it's rather bizarre

 

[jdraw]

Can you post a copy of you data base (no confidential info)?

 

[Pat Hartman]

You do realize that there is a 1-many relationship between parents and children and it doesn't make any sense to poke child data into a parent record. You would actually need to be positioned on a child record and do something to make your code run before it would update the parent record.

 

[Super Suarez]

Well in the end it worked via the following:-

[List num] = tempnum

Which I thought was a bit strange. I have got my terminology right here for parents and child. The main form has a button which opens a further form (which I believe is the child) right? It is in this child form that I have the above code which then updates the main form.

 

[jdraw]

Form and subform (Parent/Child forms) are discussed in this youtube video
http://www.youtube.com/watch?v=YZKN_-P6wck