The value of a cell in a VBA variable

Hello,

I'm following up on your topic because I'm having trouble assigning a value from a cell (variable cell) to a variable.
For clarity, I’m copying my line of code with the error that VBA indicates in bold underline:

Dim x As Integer Dim y As Integer x = <bold><underline>Sheets("Planning Relogement Tour").Cells</bold>(n, "I").Value</underline> y = Sheets("Planning Relogement Tour").Cells(n, "F").Value If x < y Then Worksheets("Planning Relogement Tour").Cells(n, "G").Value = "" m = m + 1 Else a = a + 1 End If Wend End If

I'm stuck and can't find out why this isn't working.
Can someone help me?

Thanks in advance

Hello,
I need a VBA code for an Access 2003 form that can change the balances of the text boxes:
- Initial Balance
- Final Balance
Knowing that the Final Balance of the current operation should be the Initial Balance of the following operation.
My problem arises when I delete a record, the balances do not change and therefore they are incorrect.
Please, I need your help.

PS: The code I used to set the initial balance to the final balance is as follows:

Dim var
var = Form_Caisse.Solde_Final

DoCmd.GoToRecord , , acNewRec

Form_Caisse.SoldeInitial = var

Please, I need your help.