Select specific records from a output Form and print

[Andydr]

Hi I asked this question before and got no response. I assume that either the answer is so simple that I should know it or it cant be done. I am relatively new to Access programming and it's nuances so please bear with me.
I have created a Search form for a Form/Subform combination to allow the user to search specific combinations of Fields. The results of the search (say 10 records)are then displayed on a separate summary form (Continuous type), with only specific fields being displayed(it is based upon a query). What I want to do is add a check box or field to this form, that the user can tick to indicate which of these records they want printed onto a report. It could be all or only one. I have tried unsuccessfully with this, if I add an unbound field then all records are ticked or not, I have tried binding it to primary key field and get an error, the only way I did achieve it was by creating a form of 2 fields, one a check box the second based upon the primary key, and then adding it as a sub form to the Summary form but now you cant use the summary form as a Continuous type?
What is the easiest way to do this?
I also need to be able to print the selected records as a report but only using some of the fields from the summary form.
Hope that makes sense. Thanks

 

[DanJR]

Hi there,

is there any reason for using the subform to display the results of a search? Another way to do it, would be to use a listbox to display the search results and set the multi select property of the listbox to 'simple'. The user can then highlight one or more records for displaying in a reporting.

Cheers,
Dan

 

[Andydr]

Thanks Dan, No particular reason for Subform, so will give this a go and see if this gives what I need. I may be back with questions around printing to report?
Thanks again.