RE: Cycle Property Problem!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Ofer" <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 9 Aug 2005 15:26:05 -0700

Try abd write on the on the on current event of the sub form
If Me.RecordsetClone.RecordCount >= 1 Then
Me.AllowAdditions = False
End If

"John Piotrowski" wrote:

> I'm having a problem that I'm sure others have experienced. I have a form
> with a subform and I only want 1 record added in the subform. I set the
> CYCLE property to "Current Record" and that prevents the TAB key from
> advancing to the next record but the PGUP and PGDN keys still take you to the
> previous and next records. I do not want this to happen. Is there a way to
> stop it?
>
> John
.

References:
- Cycle Property Problem!
  - From: John Piotrowski

Prev by Date: RE: Create a button to save/update record OR add new record
Next by Date: Re: Pop up Form Placement
Previous by thread: Cycle Property Problem!
Next by thread: help with data entry
Index(es):
- Date
- Thread