limit the user

[Richard]

I have a small popup form, table and report. I have a single record in this
table. I would like to limit the user to this default record or let them
edit it, but not create any new records. In other words, I don't want more
than (1) record in this table. Is this possible? This popup form is called
from a command button on my main form.

Thanks
Richard

 

[Pete D.]

A trick I use is to make a extra keyfield do not allow updates. Give it a
default value of X and a validation rule of X and place an X in it. Add a
error message for the validation rule that tells user they cannot add
records to this table and hide the table and prevent user from unhiding it.
Access will prevent records from being added yet user can edit the one
record if needed.

 

[Pete D.]

Umm I said do not allow updates and I ment duplicates in keyfield. Sorry.