Preview report from a subform

G

Guest

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
 
M

Marshall Barton

stumpy said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top