Form with Subform

[jnw]

I have a form with a subform which contains records. I have a text box on the form that equals one of the records. When I choose a record it shows up on the form correctly. But when I print the form, it always prints the first record, even if I have selected the second or third record. Any ideas?

Julia

 

[jimmythegeek]

That is why reports are so much better than printing forms. Create a query that a report is built from. In the query, put criteria that refers to the form you have open.

For example, if I wanted the order that is showing on my form (frmOrder) to print out, I simply put the following in the criteria of the OrderNo field in the query:

[Forms]![frmOrders]![OrderNo]

Then build a report based on this query. When the report prints, it will print the record that is showing on the Order Form. Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[jnw]

Thank you, I will try it!

Julia