WHERE PBI.PBICCRNname = Forms!DONE!CCname;
Ive got a form called "DONE" i'm pulling a value from a combo Called "CCname" and iv'e attached this querie to the rowsource of a list box on my form.
If i change the "Forms!done!ccname" to the actual ccname "joe bloggs" i get a result, if i leave it the same "Forms!etc." i get no errors just a blank feild??
I thought i had this figures out, is there something right in front of my face?