C
Compnstuff
Private Sub PartNumber_AfterUpdate()
'Update description, rev level, and price
Me!Description = Me![PartNumber].Column(1)
Me!Revision = Me![PartNumber].Column(2)
Me!UnitPrice = Me![PartNumber].Column(3)
End Sub
-------------
PartNumber is pulling from a query.
Description is updating as should but nothing in Revision or UnitPrice.
Any suggestions?
Comp
'Update description, rev level, and price
Me!Description = Me![PartNumber].Column(1)
Me!Revision = Me![PartNumber].Column(2)
Me!UnitPrice = Me![PartNumber].Column(3)
End Sub
-------------
PartNumber is pulling from a query.
Description is updating as should but nothing in Revision or UnitPrice.
Any suggestions?
Comp