Hello all... I'm building a data base to enter sales orders and work order to track where in our shop they are at and what time they were scanned. Its a pretty basic data base, I am using a form to enter data into the external database. In my entry form I want to show all prior entries for a sales order as the user is entering more locations. I have created a query and added it to the form but dont know how to have it look up all the data in the table that is already entered. I tried "[Forms]![SO Entry]![SO Number].[OnEnter]" and all this does is add it to the query and it doesnt show all the data from the table. AS you can see below, as we are entering the SO Number and tab out of that field (or enter) and go to next field we want the query to tell us all prior entries of that same SO Number.
Any help would be appreciated.