Virtual Radio button for selecting records

ECEK

Registered User.
Local time
Today, 06:54
Joined
Dec 19, 2012
Messages
717
I have a datasheet sub Form.

What I am trying to do is have a radio button that allows be to select certain records then press a button to append the selected records.

There is no data field in the underlying (Query)Table.

If I select a radio button then all of the records are selected...or not.

Is there a way to do this without having to create a new field?
 
you may try to use an ADODB.Recordset.
google more about it.
 
Thanks Arnie
I was hoping for an easier solution tbh. The ADO route is a little our of my leage.
Thanks for the message though.
 
For each record to be able to store its selection there must be an extra field included in the form's recordset. Adding an extra field to the table works in a single user environment but not for multiple users since their selections would conflict.

Consequently, most developers do this with a temporary table for each user having the extra selection field and insert the records to be displayed into it. Then use a query based on the temporary table to write the selected records out to permanent tables.

The temporary table can be substituted with a ADODB disconnected recordset but it requires a lot more code to build and load the recordset and write the selected records to a table using loops.
 

Users who are viewing this thread

Back
Top Bottom