Jim,
I would add some code to count the records and if there are any, set the allow additions of the the subform to False.
Regards,
Duane Hookom
Sent: Thursday, January 18, 2018 5:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Limit subform to only 1 record
Hello all,
We support a database that has a Form with a sub form. I have yet figured out how the users are creating a second record in the subform. I have hid the navigation buttons so they cannot click new record or navigate to another record. The subform is linked on Person Id in the main form to the Person Id in the subform.
I thought if I try and limit the subform to only allow the TOP 1 records that would work. or try and code the OnCurrent event to stop allow.additions from happening I would solve it. But neither of these are working.
Without being able to replicate the users adding records to the subform I am at a loss on how to fix the issue. Is there a way of limiting the form to only 1 record?
the main form is all active employees. the subform is the employees schedule and hours they work.
Thank You for your help
Jim Wagner
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar