Do Loop

[Max]

I am using a do loop to check for the next empty text box in my subform. I
know the text boxes are null because if I use Debug.Print
frm.Controls("txb_name" & CStr(cnt)) it shows null . Whats the prob?


dim cnt as long
cnt =0
Do
cnt = cnt + 1
Loop Until frm.Controls("txb_name" & CStr(cnt)).Value = Null

 

[Allen Browne]

Use IsNull() instead of =Null

Nothing ever equals null. For an explanation, see Error #5 in:
Common errors with Null
at:
http://members.iinet.net.au/~allenbrowne/casu-12.html