Thank you, thank you, thank you, mmccarthy.
I just tried it and it works PERFECTLY! You are a lifesaver!!!
User Profile
Collapse
-
Query Error in VBA Access 2000
Forgive me as I am new to this forum and to Access, but here is my code. I can't get the Employee name to come up, only the Employee ID number.
...Code:Private Sub List2_AfterUpdate() With Me.List4 .RowSource = "SELECT InventoryID, Platform, EmployeeID " & _ "FROM Inventory " & _ (This is where I put my inner join to join the tables, Inventory and Employees).
No activity results to display
Show More
Leave a comment: