Access - Limit Forms to one record

[SantasLittleHelper]

Is it possible for a form to be limited to one record?

e.g. Can I make it so that 'Form1' can only edit the first record in the table? And then 'Form2' can only edit the second record?

I don't want people to be able to create new records, just edit the existing record that I'd like assigned to their form.

 

[Joe4]

You can set up a form to not allow creation of new records. Just go to the Form properties, and on the Data tab, set "Allow Additions" to "No".

You do not need multiple Forms, just one Form that is based on a dynamic query. How is it determined which record a person should see?
Just put that in the Criteria of your Query, and it will only return that record.

 

[Micron]

You can also prevent deletion of records - set Allow Deletions to No also.
(just in case you wanted to know)