please help

[Mak 7]

ho w do u pick certain field in specifiec records to show up on report all in one page, where i want them.

refer to my last post message , with the subject message design, yesterday.

thanks

 

[jfgambit]

If the report is based on a query you already have built, then you can point the criteria of the specific fields in the query at a Form. For example, if you want to pull up a specific part # then have an unbound textbox on a form called PartNumber. In the criteria of the query add the following:

[Forms]![NameofForm]![PartNumber]

The query will only pull that specific part number and pass it to the report.

HTH