updating a field based on other field

[wshs1]

so im using the dlookup function.

i have a form, and i would like to update the field "paID" when user fills out the "PrNum" field.
this is what i have.. im getting a mistype match.
so user types in the prnum, i want access to look up the tbl1_PurchaseRequisition and find the "PaID" which has the same prNum.

Private Sub Prnum_AfterUpdate()

Dim varpaID As Variant

Me.paID = DLookup("paid", "tbl1_PurchaseRequisition", "Prnum = '" & Me![Prnum] & "'")

Me.paID.Requery

End Sub

 

[jebry]

Hi!

Maybe you need to take the single quotes out of the DLookUp function assuming Prnum means that it is a number.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[wshs1]

just saw that.. but thank you~