When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
end of statement error with "NDItemNumber" highlighted. I know it has
something to do with the 2 but I can't figure hout how to get around it.
Sorry if this is a duplicated post but I don't think I posted the 1st one
correctly.
TIA
Robert Morley - 29 Feb 2008 17:30 GMT
2 is considered an invalid character to start a name with. It's okay within
a name, but not as the first character. Try rs![2NDItemNumber] and see if
that works. I believe it should.
Rob
> When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
> end of statement error with "NDItemNumber" highlighted. I know it has
[quoted text clipped - 4 lines]
>
> TIA
mcescher - 29 Feb 2008 17:40 GMT
> When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
> end of statement error with "NDItemNumber" highlighted. I know it has
[quoted text clipped - 4 lines]
>
> TIA
Cyberwolf,
.Fields("2NDItemNumber") = st2nd
Hope this helps,
Chris M.