If function (I Think! but maybe recordset??) 1

[Walshie1987]

Hi, just wondered how I would put the following into code:

(I know how do to the Dlookup part)

If the value I enter in a textbox is not found during a dlookup then leave the value as it is, if it is found in the dlookup then enter the dlookup value.

e.g
If I put "Test" into a text box and dlookup cannot find "Test" my table, then just leave the word "Test" in the text box.

If the word "Test" was found in my table then put the info from my table into the text box instead of the word "Test"

Thanks alot
Chris

 

[PHV]

A starting point:
Me![textbox] = Nz(DLookUp(you know how do to the Dlookup part), Me![textbox])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Walshie1987]

Thanks alot! Works Perfect!

Cheers
Chris