dlookup format question 1

[ProtegeV2]

I am trying to display a calculation in a form - here is the On Current I have so far:

Private Sub Form_Current()

[txtDocInv] = DLookup("[InvoicedToDate]", "[qryInvoicedTD]", _
" & [Docket #])

End Sub

[InvoicedToDate] is a calculation in a separate query (not connected to the form)

[Docket #] is a form field - when a record is displayed I want it to display the corresponding calculation from [InvoicedToDate].

Can you tell me what I am missing? Thank you.

 

[SnaveBelac]

You need to specify which form to look for your form variables and your criteria must be in the form of an SQL WHERE clause.

Assuming your unique field in your qry is [InvoiceID]

Private Sub Form_Current()

[b]me![/b][txtDocInv] = DLookup("[InvoicedToDate]", "[qryInvoicedTD]", [b]"[InvoiceID]=" & me![Docket #][/b])
    
End Sub

HTH

----------------------------
SnaveBelac - Adventurer

http://www.hostpipe.co.uk

 

[ProtegeV2]

Thank you, that's what I needed!

 

[SnaveBelac]

Glad I could help

----------------------------
SnaveBelac - Adventurer

http://www.hostpipe.co.uk