Recent content by U812B4

Success I actually did what was suggested above and that was adding a subform instead. I tried your method and I am sorry but it did not work for me, I do appreciate the help thou! Thank you!

Success After many hours of racking my brain to use this information I have finally found success! Not only did I attain what I was looking for but I learned as well.

Would this not require me to enter the work order then as many times as I have travelers? The way I have the form setup now, the user enter the work order number, po number, etc and in the traveler fields the traveler numbers that will be assigned to that work order.

I have (7) traveler fields because one work order may have multiple travelers assigned depending on how many steps it may need to get the work done. Sometimes we may have a traveler number and need to know what work order it belongs too. I have done as you suggested and I am not getting any...

How do I write a query that will do a search across (7) fields after a parameter has been entered? In my table I have (1) field that has WO Number and (7) with: Field 2: Traveler 1 Field 3: Traveler 2 Field 4: Traveler 3 to Traveler 7 When trying to view the Traveler Report I would like the...