Search results

Thanks Pat. That is what I will have to do. I tried what I mentioned previously and it only pulls the first record off the list of queried results. Oh well this should have the query taking less time than if I had to populate all of the information in the other form.

Doc Man I agree ideally all of these notes would be in a notes field for the item record. Easy to search and is tied directly to the item. Unfortunately the data was dumped from symix syteline in 2007. This is how the data was stored there and referenced. The bad part was the data was just...

Well, I am glad to see it is not just me. I really do try hard to accomplish my goals before reaching out. So yes I could have multiple results and usually do. So lets say that I have a bearing and its manufacturer part number is 12345. Well this was never stored in the part description...

Thanks I will give everyones suggestions a try. I know the field names are an issue but I am dealing with a access97 database that was nothing but tables to begin with. I will change them but I have so much code tied up in these old carry overs I am hesitant to do anything. I should have...

No my intention is to open the form and filter by itemIDkey based on the results of a query not change the record source. The query performs a wild card search of the notes for each item. each item may have several "notes" records in a "notes" table linked by a key. Here is the original SQL...

Can someone tell me where i messed up this conversion from the query builder SQL to VBA. Dim Descriptionqryidkey As String Descriptionqryidkey = "SELECT Itemstbl.ItemIDKey " & vbCrLf & _ "FROM ItemsNotestbl RIGHT JOIN Itemstbl ON ItemsNotestbl.key = Itemstbl.key " &...

New member from Texas. Have been using access for over 20 years but no formal training with lots to learn still. Working for a company that thinks a proper database is a folder full of excel spreadsheets.:banghead: