Some how I got all of these Like "**" in my query Criteria, not sure how they got there. I went back to an old ver. and they weren't there ???. So I added the old SQL to my newest ver. and all seems to show as needed. What I'm working on is in my main form if I make a change I don't see it in my Search form. I tried me.requery, still doesn't update. I'm thinking it's something in the Query on the row source for the Search form. The info. is saved on main form before search and is listed in the tblParts Table.
tblParts.P_Tag is the field I need updated. I changed tblBins.Bin_Tag, but still the same.
Just need a little help where to go.
Thanks,
Tom
Code:
SELECT tblParts.P_ID, tblParts.P_Name, tblParts.P_Number, tblParts.P_Type, tblParts.P_TypeSub, tblParts.P_Value, tblParts.P_ValueType, tblParts.P_Rating, tblParts.P_RatingType, tblParts.P_Quantity, tblParts.P_Date, tblParts.P_Location, tblBins.Bin_Tag
FROM tblBins INNER JOIN tblParts ON tblBins.[Bin_ID] = tblParts.[P_Location]
ORDER BY tblParts.P_ID DESC , tblParts.ExtraFld, tblParts.P_Value, tblParts.P_Type, tblParts.P_TypeSub;