Hello,
I need to print out 2 different reports depending on the user input from the form.
In the above screenshot the top is the form. If the user fills out a date in the expiration date field then the label in the middle will print out. If there is no expiration date then user can select the "No Expiration " button on the form and the report on the bottom will print out.
In either case the Control number on the reports will need to automatically increment by 1 number. This will be a unique number stored in the table.
Is there an easy solution to accomplish this?
I have created the form and 2 reports and they work independently. but when I try to use either or I cant get them to work off the form.
I am guessing there must be an if/then statement somewhere along the lines just can figure where it should be or how to implement it the most effecient way.
Thanks for any input you can help with.