Default value based on another table

[dark11984]

Hi,
I'm trying to get a ExpConnote field in TblExpresPost to be the default value of InvConnote field in Tblinvoice. ExpConnote needs to remain as the default for any new entries in TblInvoice until a new ExpConnote is entered.

Can this be done? I've tried searching other sites and I saw something that looked like this, but I can't get it to work.

Dim strFilter As String

strFilter = "ExpConnote = " & Me!InvConnote
Me!ConNoteNSW = DLookup("InvConnote", "TblInvoice", strFilter)

Thanks.

 

[marianne]

wow. sometimes my mind is entangled that I cannot seem to understand. lol. maybe you can attach your db here so we can see it.

 

[dark11984]

All good... fixed now. Thanks!