Selecting records from a continuous form

[JORAM]

I have a search form that displays the results in a continuous form.  I would like to be able to select records from this form that will then be displayed in a report.  Any ideas?

 

[rbowes]

One thing that I would do is to place a control on the search form that was bound to the record's Unique ID (whatever you have decided to use as a RecordID ).&nbsp;&nbsp;SInce its a search form, I would disable and lock all of the controls on the form except the ID control.&nbsp;&nbsp;You can place a command button on the form that will open up a form or report to the value you have highlighted(By the way, if you allow record selectors to be enabled you will not have to enable any of your controls on the form and the ID control can be invisible).<br><br>I assume that you have a query as the recordsource of the report.&nbsp;&nbsp;In the ID field's criteria row I would place: Forms![MySearchForm]![txtID].<br><br><br>When the report is run, the query understands that the ID field on that form is needed to run.&nbsp;&nbsp;Only those records with that ID will be selected.<br><br>Hope that helps.

 

[HIM]

Or you could just ad a field of Yes/No type, only visible in that window. The user can then select what records he wants to see, and they are easy to select via SQL. Just remember to clear the field by an update query when closing report.

 

[JORAM]

I have created the Yes/no field on the form which allows me to select the records I want but when I run the update query only some of the records are cleared, although the database appears to know the records are cleared as it gives an error message.&nbsp;&nbsp;I have tried compacting the database, but it hasn't helped.&nbsp;&nbsp;I can't think of anything else??