Mak 7
05-13-2003, 08:33 AM
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
05-14-2003, 09:14 AM
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