I currently have three tables. One is the main table called defects that has a tracking number. I have another table called closeout reference that has a tracking number (which ties it do the main table) and a action number ( which ties it to my third table). I then have a third table called closeout action that has the action number and the actual action names.
With that in mind i have a query that I am using to create a report which prints all of the action names where there is a reference to that action in the second table. I then have a button on one of my forms that I want to press that will call the openReport command. I pass the report a where the tracking number equal a value from the form field. When I do this, I recieve a box that asks me to enter a tracking number. When I do this the correct results are printed. Why wont it just pass the tracking number? If this is confusing let me know. Thanks
With that in mind i have a query that I am using to create a report which prints all of the action names where there is a reference to that action in the second table. I then have a button on one of my forms that I want to press that will call the openReport command. I pass the report a where the tracking number equal a value from the form field. When I do this, I recieve a box that asks me to enter a tracking number. When I do this the correct results are printed. Why wont it just pass the tracking number? If this is confusing let me know. Thanks
