Error 2455 when tabbing to new record

[GummowN]

This may just me being a complete arse but the following code works fine if you navigate through the records but when you tab from the final field of the form to a the next record you get 2455 invalid reference to the property form/report.

Any ideas welcome and thanks in advance

Private Sub Form_Current()
' Look a Warning
Me.Detail.BackColor = -2147483633
Me.ReportCategory.Form.Detail.BackColor = -2147483633
Me.ReportCategory.Form.FormFooter.BackColor = -2147483633
Me.ReportCategory.Form.FormHeader.BackColor = -2147483633
Me.clockDate.ClockDigitColor = 16777215
Me.clockTime.ClockDigitColor = 16777215
Me.clockDate.ClockFrameColor = -2147483633
Me.clockTime.ClockFrameColor = -2147483633
etc

Error occurs on the subform referenced lines

 

[ToeShot]

Are you tabing through fields on a subform? if you are it will not display the next record since the parent record has not moved to the next one.

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[GummowN]

I am tabbing through the main form

 

[ToeShot]

Have you tried setting the subform so it does not have a tab stop? I am not sitting in front of my PC so I can't check the properties nor do I remeber them all

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[GummowN]

That makes no difference to the result.

Any other suggestions?

 

[ToeShot]

Not sure what to say here, I would probally comment out the the code then uncomment one line at a time to see if there is an actual problem there

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait