jeff.embury at mac.com
jeff.embury at mac.com
Tue Jan 31 10:12:20 CST 2006
I have a form I'm constructing that has twenty one check boxes on it... twenty one labels, twenty one of a lot of things... and I'm trying to alter there values in a simplified way by hopefully using the Eval function - but it's not working as advertised. The Scene: Microsoft Access 2003 in vba code... Check box names: Check1, Check2, Check-etc. Function to turn all check's 'on' or 'off': Function TurnMeOn(bWhichWay as boolean) Dim n as integer Dim s as string n = 1 Do While n < 21 s = "form!formname.check" & trim(str(n)) & " = bWhichWay" Eval (s) n = n + 1 loop End Function ================This doesn't' work=============== (sigh!) ...if fact hardly nothing works with the Eval function as I see it... Microsoft plainly states that the Eval function can call a user defined function - but if I create a function called... let's say "TESTIT()" and then use Eval("TESTIT()") it pukes... Any help or is there a much more brilliant solution I'm unaware of?