Form with Subform

jnw · Jan 3, 2001

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 · Jan 3, 2001

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 · Jan 4, 2001

Thank you, I will try it!

Julia

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Form with Subform

jnw

Technical User

jimmythegeek

Programmer

jnw

Technical User

Similar threads

Part and Inventory Search

Sponsor