check if the product_id is in integer or string form. if it is string form you have to put "'"product_id"'" as a criteria
S.Shamael --- In [email protected], "chadcbc" <[EMAIL PROTECTED]> wrote: > > I keep getting a data type mismatch error, not sure how to fix it. > Here is my code: > > Private Sub ProductID_AfterUpdate() > strFilter = "[ProductID] = " & Me!ProductID > Me!UnitPrice = DLookup("[UnitPrice]", "Products", strFilter) > End Sub > > Thanks > ~Chad > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
