#error using dlookup

[raviyah]

I have a dlookup in a text box on a form.
=DLookUp("username","tbluser","userid= " & [txtuserid]))

If there is a value in txtuser then the dlookup works fine. if not, I get an
#error in the text box. i have tried iif(..) but can't get the message to go
away.

 

[Stuart McCall]

I have a dlookup in a text box on a form.
=DLookUp("username","tbluser","userid= " & [txtuserid]))

If there is a value in txtuser then the dlookup works fine. if not, I get
an
#error in the text box. i have tried iif(..) but can't get the message to
go
away.

Try using the Nz function ('Null to Zero'), like this:

=DLookUp("username","tbluser","userid= " & Nz([txtuserid])))

 

[raviyah]

still get #error message

I have a dlookup in a text box on a form.
=DLookUp("username","tbluser","userid= " & [txtuserid]))

If there is a value in txtuser then the dlookup works fine. if not, I get
an
#error in the text box. i have tried iif(..) but can't get the message to
go
away.

Try using the Nz function ('Null to Zero'), like this:

=DLookUp("username","tbluser","userid= " & Nz([txtuserid])))

 

[raviyah]

Using the valueifnull argument solved the problem. Thank you

still get #error message

I have a dlookup in a text box on a form.
=DLookUp("username","tbluser","userid= " & [txtuserid]))

If there is a value in txtuser then the dlookup works fine. if not,
I get an
#error in the text box. i have tried iif(..) but can't get the
message to go
away.

Try using the Nz function ('Null to Zero'), like this:

=DLookUp("username","tbluser","userid= " & Nz([txtuserid])))

Text fields must be delimited in quotes.
Also is txtuserid the name of the textbox or a field name?

DLookUp("username","tbluser","userid= '" & Nz([me.txtuserid],"") & "' )"

That's single quote double quote after the equal sign and double quote
single quote before the ")"
You also had three ")" where there should be two.