D
Dan
I am prototyping an application involving a timer on a
form. On my form, I have an unbound control linked to a
table having only a counter field, updated every second by
the timer initiaiting a macro.
As this macro runs, after the counter is incremented, I
inserted a condition such that if the value of the control
= 4, then perform and update by executing the following 4
commands in the maco ( identified with ellipses in the
condition field).
In the macro, I entered into the condition field the
statement :
[forms]![Main Form]![list9] = 4
(this is the unbound control on the form tied to the
[counter]![count] field, in whuich there exists only 1
record containing the current count of seconds.)
If this statement is true, I want the macro to execute the
elllipses statements following the condition.
I hope you can see that what I am trying to do is "read"
the value of a unbound control on a form and apply a
numeric condition to it.
I have Access 97 running on NT 4.0. I have been getting
compile errors when using the statement [forms]![main
form]![list9].recordsource.
Can you tell me what statement I can use which will help me
in reading the unbound control.
Thanks
Dan
form. On my form, I have an unbound control linked to a
table having only a counter field, updated every second by
the timer initiaiting a macro.
As this macro runs, after the counter is incremented, I
inserted a condition such that if the value of the control
= 4, then perform and update by executing the following 4
commands in the maco ( identified with ellipses in the
condition field).
In the macro, I entered into the condition field the
statement :
[forms]![Main Form]![list9] = 4
(this is the unbound control on the form tied to the
[counter]![count] field, in whuich there exists only 1
record containing the current count of seconds.)
If this statement is true, I want the macro to execute the
elllipses statements following the condition.
I hope you can see that what I am trying to do is "read"
the value of a unbound control on a form and apply a
numeric condition to it.
I have Access 97 running on NT 4.0. I have been getting
compile errors when using the statement [forms]![main
form]![list9].recordsource.
Can you tell me what statement I can use which will help me
in reading the unbound control.
Thanks
Dan