No.
Unless you added water park fun for about $58. in which case you use the same ticket card. Entering a water park will not use up a theme park day at that moment.
One visit to one water park or Disney Quest all vacation long? Buying an individual ticket (approx. $48.) for that minor park is better than the water park fun on your theme park ticket.
There are some promotional (and non-upgradable) tickets that have three theme park days plus one water park visit which will do what you originally asked although they have significant other limitations.
If you bought the single water park or DQ ticket and then decided you want to go again, you can take that spent ticket, your regular theme park ticket, and about ten dollars and end up with water park fun on the regular ticket. Does not work with promotional tickets.