Preview report from a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stumpy - 02 Nov 2007 16:55 GMT

Is it possible to preview a record by clicking on it in a subform?
I have a form: NonCompliance on which I have a subform to view all
NonCompliance records. At the moment I ‘m using a button to preview using the
ID number of the record to select the record to preview.
Subform fields are ID, CompNo, Class, Date all from Table;tbl2Non-Compliance

Any help would be greatly appreciated

Reply to this Message

Marshall Barton - 06 Nov 2007 00:10 GMT

>Is it possible to preview a record by clicking on it in a subform?
>I have a form: NonCompliance on which I have a subform to view all
>NonCompliance records. At the moment I m using a button to preview using the
>ID number of the record to select the record to preview.
>Subform fields are ID, CompNo, Class, Date all from Table;tbl2Non-Compliance

A "record" is not something you can click on. You can click
on controls within the form or if you have RecordSelectors
set to Yes, then form's Click event will respond if you
click on the record selector. Most people use a command
button so your current approach sounds good.

Signature

Marsh
MVP [MS Access]

Reply to this Message