Determine Which Record is Selected

[Marnie R.]

I have a form that displays continuous records. It has
the record selectors displayed also.

I need to transfer selected records to a different table
for use by restricted users.

How do I determine which record(s) is selected, and what
kind of code should I use to do the transfer?

 

[PC Datasheet]

It sounds like you need a Yes/No field named Selected in your source table so
you can select the fields you want on your form. Then you need an append query
based on your source table where the criteria for the Selected field is True to
add the selected records to your table.