Argument Not optional - But no reason

[lynxbci]

Hello
I have a subform and when you double click on any field it remembers 3 fields from the record you are in and stores them. I have 3 fields called [section], [losthrs], [stdhrs]. It works perfectly and stores the data from [losthrs] and [stdhrs] fields, but throws up "Argument not optional" for the [section] field.... Can not see a reason why, it is just a simple text field...

I have even tried 'pausing the code' and using the immediate window to show the field values, again losthrs and stdhrs are fine, section gives "Argument not optional"

Am i missing something, i am going mad because it make no sense to me....

thanks

 

[MarkK]

This error occurs in you make an otherwise valid call to a subroutine, but you don't supply enough parameters, so if you have this sub . . .

Sub DoSomething(prm1 as single, prm2 as single)
   'does something
End Sub

. . . and you call it with code like . . .

   DoSomething 1.234

. . . you'll get that error.

 

[lynxbci]

Thanks, but i do not have a sub routine called "section" it is just a field name. So therefore has no parameters?

 

[CJ_London]

Section is a reserved word (relates to sections on a form or report) so using it can cause problems. Suggest try changing it to something else

here is a list of reserved words

https://support.office.com/en-in/ar...-symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe

 

[lynxbci]

Thank you so much, that must be it. I am indebted to you. Have a good weekend.