Iterate using variable as part of string

[Guest]

I want to iterate over field names which are identical except for a single
digit(e.g. the field names are House1, House2, House3 and I want to have a
line of code which tests conditionally If House" i" <> 0, etc.) What is the
proper combination of quotes and ampersands?

 

[ruralguy via AccessMonster.com]

Post back if this link is not enough help.
http://www.mvps.org/access/forms/frm0003.htm

 

[Guest]

Thanks. I don't know why I thought it was more complicated than that.

 

[ruralguy via AccessMonster.com]

You're welcome. Glad I could help.

Thanks. I don't know why I thought it was more complicated than that.

Post back if this link is not enough help.
http://www.mvps.org/access/forms/frm0003.htm

[quoted text clipped - 3 lines]