Re: [MS_AccessPros] Limit subform to only 1 record

 

hi Jim,

additionally, for the subform set the form Cycle property to --> Current
Record

(default is All Records)

have an awesome day,
crystal

On 1/19/18 9:05 AM, Liz Ravenwood liz_ravenwood@beaerospace.com
[MS_Access_Professionals] wrote:
> I had a similar incident and I had to change the users behavior options under the file drop down for the "enter" key to not go to a new record.
>
> Respectfully,
> [RCEmailSigLogo]
> Liz Ravenwood
> Information Technology
> Interior Systems
> Rockwell Collins
> 1851 So. Pantano Rd, Tucson, AZ 85710 USA
> (520) 239-4808
> Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
> rockwellcollins.com<http://www.rockwellcollins.com/>
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
> Sent: Thursday, January 18, 2018 9:31 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Limit subform to only 1 record
>
>
>
>
>
> 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
>
> ________________________________
> From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>> on behalf of luvmymelody@yahoo.com<mailto:luvmymelody@yahoo.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
> Sent: Thursday, January 18, 2018 5:22 PM
> To: MS_Access_Professionals@yahoogroups.com<mailto: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: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

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

.

__,_._,___