Printing

[wiredgecko]

MS ACCESS

is there a way to print only selected fields from the CURRENT form?

i am very new to access and would need this to be as simple as possible.

thanks

 

[ranman256]

either make a report using only these fields,
or
a query that opens using only these fields,
from a button (turn the wizard on, then place the button)

 

[wiredgecko]

either make a report using only these fields,
or
a query that opens using only these fields,
from a button (turn the wizard on, then place the button)

i made a report but it includes ALL the records in the database. i only need the current record shown on the form.

 

[ranman256]

you must include the KEY field id in the query to it only pulls 1 record:

select * from table where [id]=forms!frmDetail!txtID

 

[Micron]

If your report is based on a table, you will have to apply a report filter. Better to be based on a query like ranman suggests.