Search results for query: *

Thanks Golom, What exactly is a rich text box?

Is it possible to use more than 1 font in a text box or label? Odd question, I'm sure. Thank you in advance.

OH GOOD LORD!!! Hello, my name is dipsh!t. The field name in the query = "cust_custid" not "cust_id" I am a big tard. I am sorry to have taken your time. The listbox passes it's value to global sting which is used in a function and the function is used in the query. amazingly enough, when...

The value ends up being a ssn. Could it be that I'm referencing a query and not a table? The query criteria is a function. The function get's it's value from "search_custid". So could it be sort of like a circular reference? in that the query uses search_custid and then a dlookup is being...

all variables are strings. search_custid is set just before the DLookup is supposed to take place and takes it value from the listbox search_custid = List30.Value I checked to see if it was passing the correct value by using a msgbox to display search_custid after setting it to list30.value...

I have changed the controlsource to value. both cust_id and search_custid are strings.

Thanks for help PH however, the error is occuring prior to setting txt_namefirst The error is in the DLookup so I'm not even getting to txt_namefirst Does the syntax look correct?

I've looked at a few FAQ's and the access help file and even some other posts but I can't seem to resolve my issue. Maybe it would help if I really understood the error message. What does it really mean? I have this in the click of a list control: blabla = DLookup("[cust_name_first]"...