Printing one field of the current record from a form

[Justin]

I need to add a command button to a form which prints a memo field just for the current record, rather than for all records. Can anyone help please?
thanks

 

[paulmcdonnell]

Justin,

If you have a report which sets up your print format and the memo field is part of the report the execution of the report should print only the required record if your report Record Source tells it to select only the report from your form.

i.e. your form should have a unique ID like CONTACTID for example which display the unique ID for that record.

The report Record Source then needs to be something like

SELECT table1.ContactID FROM table1
WHERE (((table1.ContactID)=[forms]![myform].[ContactID]));


where table1 holds your data and myform is your form where your printing from.

When the report runs it will only extract the data with the same unique ID as is diplayed on your form control... the one you want

Hope this helps

paul