Record Selectors in Forms

[wjoc1]

Hi,

I have a continuous form which displays records from a particular table. I want to be able to select a number of records using the record selector on the form and then displays only those records on a report. How can I do this?

If I use an "Open Form" button I can open another form and display these records but unfortunately this will not do. Why can't I do this with an "Open Report" button?

Liam

 

[audrey]

You could create a form based on your table that asks for a beginning record and an ending record, you would then have a query that uses the parameters from that form, then have a report based on that query.

In essence, you would click the "Select Records" button on your form. You would then enter a beginning record and an ending record, then your report would open with only the specified records.

If you want to do this, i'll be happy to help you.

 

[ghudson]

I would add a new field to your table and a check box to your form. Filter your reports data source by the value of the check box to print or not print the checked (selected) records.

HTH

 

[wjoc1]

Thanks, adding the checkbox is actually what I ended up doing because I couldn't find another way around it! thanks for the help

Liam