STUPID, STUPID, STUPID ME!!!

MY LORD!! Thru sheer chance I stumbled upon my problem...in my SELECT statement I was issuing a join statement in which I told it to join on the part# ie:

SELECT PART#, DESCRIPT, ONHAND, LOCATION;
FROM INONHD RIGHT OUTER JOIN INMAST;
ON INMAST.PARTNO=INONHD.PARTNO;
WHERE INONHD.LOCATION=THISFORM.TXTLOC.VALUE AND;
INMAST.PARTNO=THISFORM.TXTPARTNO.VALUE

DUMBASS ME!! I've been fiddling around all this time, when all I needed to do was include the location search in the ON like this...

...ON INMAST.PARTNO=INONHD.PARTNO AND;
INONHD.LOCATION=THISFORM.TXTLOC.VALUE;
WHERE INMAST.PARTNO=THISFORM.TXTPARTNO.VALUE

Once bumbled accross the above it gave me a select with all the part numbers and descriptions, etc. but those that didn't have a value in the onhand table and of course didn't have a location number, came up with part number and location = .null.!!!! Then all I had to do is add an IIF() to the fields affected and viola!!! DAMN!!! Ah well, I've learned alot from your help...so I want to thank everyone that patiently gave me replies and help:)