Cycle Property Problem!

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cycle property of subform doesn't perform as advertised ??? 1
Access 2007 Spell Check 2
Access 2002, prevent mouse wheel from cycling to next record? 1
Form entry order 24
Preventing PageUp/PageDown navigation 7
Record selector/cycle not working 1
Subform counts records in reverse order 7
Can keyboard keys be disabled?? 6

Top