Single entry in subform

[Neil Hiorns]

I have a subform which allows, as you would expect, the entry of data. However, on this particular subform I do not want the use to move to the next empty record.

I have removed navigation keys, added the remove mouse scrolling and also prevented Page Up/Down. I cannot prevent going to the next record by using either the tab or cursor down, can this be done without removing the tab function?

 

[Wayne Morgan]

Setting the subform's Allow Data Entry property (Data tab) to No will
prevent entering new records. However, it sounds as if you may want to
change the Cycle property (Other tab). Set it to Current Record.

 

[Neil Hiorns]

Yes, the cycle property fixed the problem, many thanks.