VBC error: sbf cannot be found

[hamzack]

Hi!

I'm in the midst of a database where a subform 'producttotal' textbox 'txttotal' would be automatically filled with a value from the mainform combobox 'product'. my code is
Private Sub Level_AfterUpdate()
Forms!sbfproducttotal![txttotal] = Me![product].Column(1)
End Sub

However, on testing it, I get a runtime error 2450. MS Access can't find the 'sbfproducttotal' referred to.

Do you have any idea what the problem is? Any words of advice would be welcome. Thanks!

 

[pbaldy]

The reference to the subform is incorrect. Here's a good reference:

http://www.mvps.org/access/forms/frm0031.htm

 

[MStef]

Hello hamzack!
Try this.

Forms!MainFormName!SubFormName!FieldName = Me.Product.Column(1)

 

[hamzack]

Thank You!!

Thanks a lot guys, worked perfectly fine!