> 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