I'm trying to populate a field from another field. I want to enter a product name and have the unit price pop up in another field. Here's what I've written (please keep in mind my only education in Access is basically Northwind). I don't understand all the terms and functions behind Access.
Thanks,
Don...........

Private Sub ProductName_AfterUpdate()
On Error GoTo Err_ProductName_AfterUpdate

    Dim strFiter As String

    'Evaluate filter befroe it's passed to DLookup function.
    strFilter = "ProductName = " & Me!ProductName

    'Look up product's unit price and assign it to UnitPrice control.
   Me!UnitPrice = DLookup("ProductName", "Products", "UnitPrice = " & UnitPrice)

Exit_ProductName_AfterUpdate:
    Exit Sub

Err_ProductName_AfterUpdate:
    MsgBox Err.Description
    Resume Exit_ProductName_AfterUpdate

End Sub

Can you post the entire error here?

_________________________
- Vijay G
Strive for Perfection

If you are looking for UnitPrice to be returned from DLookUp then you got to change it as... Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Thank you very much. I think I see how this is done and actually I've added another pop up field to my form based on what you showed me.
Thanks again,
Don........

No Problem. You can check this out for better understanding of DLookup Function.

Description of DLookup() usage, examples, and troubleshooting in Access 2000

Cheers!

_________________________
- Vijay G
Strive for Perfection