Cycle Property Problem!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top