How to tab thru existing records, but not new record

How to tab thru existing records, but not new record

Post by Dean Slind » Thu, 13 Nov 2003 09:07:39


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?
 
 
 

How to tab thru existing records, but not new record

Post by Wayne Morg » Thu, 13 Nov 2003 16:54:01

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.

--
Wayne Morgan
Microsoft Access MVP




on
to
"new"
record.
"CurrentPage"