Hello all!
I have a subform that I want to lock so it can only allow one record entry. Example -- This database is used for internal file audits -- There is a table with all the file information -- A table with all the audit information.
The Main Form is the file information -- the subform is the audit information for that particular file.
There won't be two audits on one file, so I want that subform to only allow one entry. How can I force it to only allow one record?
Please let me know if you need any further information! Thank you!