Cycle All Records not working as expected

[Bob H]

I have a form with a drop down combo box and a number of fields for a
specific type of record selected from the combo box.I have 'Tab order'
set at auto to cycle through the fields but when the tab gets to the
last field it stops and won't tab back to the first field of a new
record or next record.
If I change it to 'current record' or current page', it will tab along
to the beggining of the same record, and wont move to next record, but
as soon as I change it back to 'All records'it stops at the last field
of the current record.

I have other forms where the tab will move on to the next record, but
this one doesn't for some unknown reason.
Anybody?

Thanks

 

[Allen Browne]

Sounds like you have something going on in that form that either stops the
record being saved, or else dirties it again as soon as it is saved.

To verify if that's the case, set the form's Record Selector property to
yes, so it shows the Record Selector at the left of the screen. The icon in
the RS is a pencil if edits are in progress, or a sideways triangle
(pointing to the record) if the record is not dirty.

For example, you may have code in the form's AfterUpdate event that assigns
a value to a bound control, so it dirties the form again every time as soon
as it is saved. When you save that, the code dirties it again, so it can't
move to another record.

 

[Bob H]

I set the form's Record Selector property to Yes,and the icon to the
left was as you described, in that it changed to a pencil when an edit
was in progress, but when using the tab to cycle throught the fields, it
again stopped at the the last field, which is DateAdded.

I do not have any code in the form's AfterUpdate event nor do I have any
code in the DateAdded 'Got Focus' or 'AfterUpdate'
I do have code in the DateEdited 'GotFocus' event: Me!DateEdited = Now.

Thanks

 

[Bob H]

I set the form's Record Selector property to Yes,and the icon to the
left was as you described, in that it changed to a pencil when an edit
was in progress, but when using the tab to cycle throught the fields, it
again stopped at the the last field, which is DateAdded.

I do not have any code in the form's AfterUpdate event nor do I have any
code in the DateAdded 'Got Focus' or 'AfterUpdate'
I do have code in the DateEdited 'GotFocus' event: Me!DateEdited = Now.

Edit:
Oops,just realised I have DateAdded and DateEdited wrong way round.
Me!DateAdded = Now, but DatedEdited has no code, which is the last field
on the form.

 

[Allen Browne]

So DateAdded is the name of the last text box in the form's tab order.
Temporarily remove any code in the events of this text box to see if that
makes a difference.

What behavior do you see? Does the focus stay in DateAdded? Or does it jump
to the first (or another?) control in the form's tab order?

 

[Bob H]

Ok I removed the code from DateAdded, but the problem still remains, and
the focus stays in the DateAdded field.
I did notice however that as I am using a split form in Access2007, if I
change it to Form only, the tab order moves on to the next record!.

Thanks

 

[Allen Browne]

Very strange. Something else must be interfering. Possibly another process,
such as a Requery, the Timer of a form, or somthing like that.