Comparing textbox values to table records.

[Porsche996GT2]

First of all, I'm sorry if this sounds stupid as I've just started programming in Access. Anyway, as the subject goes, how do I compare textbox values to table records? Do I have get the table rows and store them in an array first? If so, how do you compare the textbox value to any of the items in the array? Any help would be greatly appreciated.

Thanks!

 

[PHV]

Take a look at the DLookUp function.

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

 

[Porsche996GT2]

Hello PHV,

Thanks for your reply. I checked the VLookup function and it should theoretically do what I want to. However, it's giving me a "Runtime Error 2001: You cancelled the previous operation." Do you know what I'm doing wrong?

Thanks,

Marvin