how to check for a value???

[yogi]

varname = test1, test2



for x = 1 to 2
flda = "test" & x
if flda = "1" then
flag=true
else
flag=flase
endif
next

I have new variable name call test1 and test2. I want to check if the value of both of these fields are equal to 1. The code above its not working and I'm missing something. What is the syntax to check FLDA?

 

[CyberLynx]

have new variable name call test1 and test2. I want to check if the value of both of these fields are equal to 1.

Are they Variables, Controls, or Fields...which is it?

.

 

[yogi]

trying to populate a check box using values from a recordset

 

[gemma-the-husky]

if field "test1" is a field in a recordset then

you need

myval = rs!test1 or
myval = rs.fields("test1")

so you can say
flda = "test" & x (where x is 1)

and then
myval = rs.fields(fllda)

ie not quite in the way you were trying

 

[yogi]

thanks for the info