Select records in Non-updateable form

[stepone]

Hello,

I have a form displaying a list of people, with selection criteria in the form header which lets the user search for records.

The underlying recordset is based on a Group By query and therefore cannot be updated.

The trouble is that I want the user to be able to somehow select a subset of the records displayed on screen. This would then be used to drive a report being printed, or an export to Excel, only for the selected users. Eg. They might select all Dublin based people and then randomly select a handful to invite to some event.

My plan was to have a checkbox for the user to select records, bound to a field in the main table, but since the recordset is not updateable, the users cannot change it's value.

Is there any way around this, or can anyone suggest an alternative method ?

Thanks very much,
Stepone

 

[MatMac]

I've got round the selection of complex sets of records by the use of a check box field in the underlying table.

I think you may need to add such a field, but utilise it in the original selection of your filtered recordsets, rather than by using GroupBy query. I.e., based on the choices your users make to obtain the original recordset, use a update queries to set the checkbox fields to -1 and display those fields.

Hope that's of some help.

M.