Loop issue

[dragon_sun252]

Correction it was ALT_TIME7 null false line

[Bob Fitz]

On which line does error happen.

[dragon_sun252]

If IsNull(Me.ALT_TIME7) = False Then

[dragon_sun252]

If IsNull(!ALT_TIME7) = False Then - I can not type today

[Bob Fitz]

why can't you do that.

[dragon_sun252]

why can't you do that.

?? Not quit sure what that was directed at but the error is at

If IsNull(!ALT_TIME7) = False Then

I have verified that it is bolth on the page and in the quiry that the page and VBA pulls from.

[Bob Fitz]

Try
If Not IsNull(!ALT_TIME7) Then

[dragon_sun252]

Same Error

[Bob Fitz]

I'm pretty sure that the "Not in this collection" error message means that it can't find a field in the recordset with the name ALT_TIME7
Check that it is spelt with an underscore and not a space. If it has a space the name will need [] brackets [ALT TIME7]
It might be worth trying the square brakets anyway. Post back with your results.
I must get some sleep now but I will check in again as soon as I wake up in the morning.

[dragon_sun252]

After some changes and fixes got and error on this line

.Update

Error 3003 could not start transation, to many transactions are already nested

[Bob Fitz]

Insert the following line, just before End Sub

Set currec = Nothing

Also, try rebooting your pc