[MS_AccessPros] Dlookup issue

 

Hi,

 

I have a main form (tblmanifest) and a sub-form (tblentrylog).  After populating the main form which includes a field called mawbno I then go to the sub-form to enter the client via a combo box.  After I enter the client I want to be able to check to see if I already entered data for that client and display a message that the client already exist.  I was attempting to use the code below in the After Update property but getting "invalid use of null".

 

Dim varx As String

varx = DLookup("[clientno]", "tblentrylog", "[mawbno] = " & Me!mawbno)

 

Note that the mawbno is also saved in the tblentrylog.

 

Any assistance would be appreciated.

 

Thanks

Toukey

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___