getting number from a subform

[Simon]

I have a Suform on my form with data in



I wnat a clik button on the form that will put the last recored from
the sufmorm into a text field on the form

i have tried this code but it does not work

Private Sub Command48_Click()
test = [Forms]![frmManufactureTubExtras]![ExtraIDNumber]
End Sub




Whats wrong ??


Thanks

 

[ruralguy via AccessMonster.com]

Here's a link to add to your favorites:
http://www.mvps.org/access/forms/frm0031.htm

In this case, if frmManufactureTubExtras is the name of your *SubFormControl*
and you are executing from the MainForm that holds the SubForm then:

test = frmManufactureTubExtras.FORM!ExtraIDNumber

should do it. Look at the link I supplied. I made several assumptions and
they could be wrong.

I have a Suform on my form with data in

I wnat a clik button on the form that will put the last recored from
the sufmorm into a text field on the form

i have tried this code but it does not work

Private Sub Command48_Click()
test = [Forms]![frmManufactureTubExtras]![ExtraIDNumber]
End Sub

Whats wrong ??

Thanks