Solved Adding field values in VBA (1 Viewer)

[ClaraBarton]

Do While intLane < Me.[StartLane] + Me.[NoOfLanes] + 1

StartLane = 41
NoOfLanes = 3
Wanted answer = 44
Returned answer = 414

How do I return field values instead of text?

 

[pbaldy]

Sounds like StartLane (at least) is being seen as text. Either fix it in the source table, format the textbox, or wrap the reference in CInt() or the appropriate conversion function.

 

[ClaraBarton]

it's not a field just a form box. ... Oh rats! of course it's in the format. I apologize.

 

[pbaldy]

No worries, does that mean it's working now?

 

[ClaraBarton]

Yes, it is working. I just needed to set to general number in format and I was looking at the data tab instead. Thank you.

 

[pbaldy]

Happy to help!