limit the user

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
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.
 
Back
Top