Hello all,

I have a report that is used to order parts and send to the customer for their files. In some cases I want the defective parts returned. In the past 99% of the parts were returned so the text box was always part of the form. Now I only have a very few occasions when parts are returned.

Here is what I want to do. On my order form I want a check box or command button to add the text to the report and when it is not checked the text is not.

Any ideas?

Thanks

It sounds like you are saying you print a report with many parts. Some parts on the report should be returned and some parts on the same report should NOT be returned.

If that is the case, a button on a form will not help you. You need to record the Parts in a table and mark each row as "returned" or not "returned".

Then you can create an expression in the REPORT that will print "Returned" or something when the table field says "returned".

HTH,
RichM