Search Form - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search Form

Robert Wilson

3 years ago

I have an asset tracking database I created and I am trying to make a searchable form. The form has three main tables; Manufacturers, Products, and Assets. I used the example from the Tech Help Video "Search Form 2.0" and used the VBA code to make a searchable form.

The issue I am having is that I have data in my form from three different tables. Data from the Asset table always appears. However, data from the other two tables shows up as "NAME?" in the form. I tried an INNER JOIN and then I can get data from one of the other two tables, but I can never get data from all three tables to appear in the search form. Is there a trick to using an INNER JOIN, for multiple tables? Or is that not the proper command to use for searching forms that have data from multiple tables?

Thanks for any advice/response...

Rob

	Alex Hedley @Reply 3 years ago
What's the structure and relationships of your tables?

	Robert Wilson OP @Reply 3 years ago
Alex, Thanks for the response...turns out I was able to resolve the situation today. I needed to add parenthesis into the command. I have the code at work, but will bring it home and post the solution in case it might be beneficial to others...

	Robert Wilson OP @Reply 3 years ago
The code I added that resolved the issues was: SQL = "Select * FROM (tblAssets INNER JOIN tblProducts ON tblAsssets.ProductID=tblProducts.ProductID) INNER JOIN tblManufacturers ON tblAssets.ManufacturerID=tblManufacturers.ManufacturerID" The prenethesis resolved the problem I was having where I was seeing NAME? in some of the form fields.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View