Hide error in textbox

[IKZOUHETNIETWETEN]

Guys


Im Having an error code in my textbox of my form Unit2. Its supposed to be error cus when u dont fill in a projectnr, it obviously cant find it. (The Dlook works by the way if it can find it) I just want it to hide the error when there hasnt been filled in a projectnr YET. I tried this but to no avail. Its a text value that it needs to hide by the way.

=IIf(Nz(DLookUp("KH";"Project";"Projectnr=" & [Projectnr]);"");"")

Or

=IIf(DLookUp("KH";"Project";"Projectnr=" & [Projectnr]);"");DLookUp("KH";"Project";"Projectnr=" & [Projectnr])

Or

=IIf(DLookUp("KH";"Project";"Projectnr=" & [Projectnr])=[DbNullValue];"";DLookUp("KH";"Project";"Projectnr=" & [Projectnr]))

[CJ_London]

duplicate post http://www.access-programmers.co.uk/...=1#post1456963

[IKZOUHETNIETWETEN]

The more answers the better.

[Bob Fitz]

Lack of respect for the people willing to help you = fewer answers

Good luck with your project.

[pbaldy]

The more answers the better.

This summarizes a lot of people's issue with cross posting:

http://www.excelguru.ca/content.php?184

[Bob Fitz]

This summarizes a lot of people's issue with cross posting:

http://www.excelguru.ca/content.php?184

I believe the OP has already been offered that link in the cross-post. Just highlights one the problems with cross-posting really (trying to follow more than thread on the same subject)

[pbaldy]

I believe the OP has already been offered that link in the cross-post. Just highlights one the problems with cross-posting really (trying to follow more than thread on the same subject)

Hadn't looked, but you are correct. Like many, I've spent significant time answering a question only to find it already resolved elsewhere. It's very frustrating to have wasted your time. As you suggest in post 4, I note the people who do it, and won't bother with their questions unless it's a very brief answer.