VB in access referring to subform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Richard Gilmore
    New Member
    • Nov 2006
    • 16

    #1

    VB in access referring to subform

    Private Sub Command33_Click ()
    DoCmd.Beep
    Forms![frmStock].StockQuantity = Forms![frmStock].StockQuantity _
    - Forms![FrmPurchase]![SfrmPurchase].Form![sQuantity]

    the bit in bold above keeps bringing up an error when it is supposed to to refer to feild sQuantity in SfrmPurcahse it thinks it is looking for a field called SfrmPurchase in frmPurchase please help I'm at a loss
Working...