How to tab thru existing records, but not new record

[Dean Slindee]

On a subform: I would like to tab thru all the data fields on all records on
the subform, but NOT tab into the new record by default. If Cycle is set to
"All Records", tabbing enters the new record. The other two choices,
"Current Record", and "Current Page" limit the tabbing to only the first
record. I would like to tab thru existing records, not fall into the "new"
record, but also have the ability to use the mouse to enter the new record.


Question 1: what's the difference between "Current Record" and "CurrentPage"


Question 2: Is there a way to accomplish what I want to do?

 

[Wayne Morgan]

As you exit the last control in the tab order, you could compare the
AboslutePosition of the form's recordset to its RecordCount. If they match,
you're at the last record. Another option would be to toggle the subform's
AllowAdditions property. You would need a button or something to click on
with the mouse to AllowAdditions.

In this case, it appears that the Page option would cycle through the
current page if you placed a page break control on the form.