I have determined that it is a problem with strFilter in the dlookup
function, if I run it with no criteria it compiles, but criteria is
necessary for the function. I am still not sure of how to fix it though.
>
> 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/
