N
NetworkTrade
this works fine in my prototype form:
Private Sub ProductID_AfterUpdate()
Me.UnitPrice = DLookup("[UnitPrice]", "PeriodicalsTable", "[ProductID] =
Forms![OrderDetails subform]![ProductID]")
End Sub
but when I have this form used as a subform inside another....the
AfterUpdate throws the runtime error 2001 'You have canceled this operation'
ps - went to Forms![OrderDetails subform]![ProductID] because Me.ProductID
wouldn't work despite every possible variation attempted with "'"& not
sure if this is relevant to the Form vs subform issue here but just thought I
would throw that in.....
Private Sub ProductID_AfterUpdate()
Me.UnitPrice = DLookup("[UnitPrice]", "PeriodicalsTable", "[ProductID] =
Forms![OrderDetails subform]![ProductID]")
End Sub
but when I have this form used as a subform inside another....the
AfterUpdate throws the runtime error 2001 'You have canceled this operation'
ps - went to Forms![OrderDetails subform]![ProductID] because Me.ProductID
wouldn't work despite every possible variation attempted with "'"& not
sure if this is relevant to the Form vs subform issue here but just thought I
would throw that in.....