[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: luvmymelody@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___