How do I create a SELECT field

I want to create a form that gives users the ability to select the records they want to process. If I add a SELECT field to the table and two users do the same process at the same time they will mess one another up. Do I need to take the list of records, put them into a temporary table and add the SELECT field, or is there an easier/better/alternative way?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
This is nearly identical to this question where the alternatives are discussed:


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The simplest solution would be a selection/selected table.

In the OnCurrent() event, you would do a check of the selection/selected table to see if it includes a row for the current user and current record (ID field).  Reflect the selected status on the form.  You can probably do this with one or two additional controls on the form.  A command button will allow the user to toggle the selected status and a label will show the selected status.  You might be able to use different button colors and texts with a single control change to your form.

The simplest check would be a DLookup() function.
Do I need to take the list of records, put them into a temporary table and add the SELECT field
I support that and approach it this way:
Assume table name a(aid Primary key, f1, f2)
Code to create a_temp table.
DoCmd.RunSQL "SELECT a.* INTO a_temp FROM a ;"
Add column sel yesno
DoCmd.RunSQL "ALTER TABLE a_temp ADD COLUMN sel yesno"
Make the form record source  a INNER JOIN a_temp ON a.aid=a_temp.aid
SELECT a.aid, a.f1, a.f2, a_temp.sel
FROM a INNER JOIN a_temp ON a.aid = a_temp.aid
ORDER BY a.f1, a.f2;
Each user can run his own a_temp table and hence the selections made.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rob4077Author Commented:
Thanks for the suggestions. I've been unable to return to this project for the last few days but will try the suggestions on Friday before I close out the question.
Rob4077Author Commented:
Thanks very much. Sorry for the delay. All the options provided seem to be easy enough to work with so I will share the points. Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.