help with continious forms

[Guest]

hi,

i am trying to build a continious forms for task management within our
stsyem. there are several stages of tasks and a client can be at any stage a
particular time.

i want to be able to edit all of these tasks without needing to go into each
client.

the problem i am having is that even though i have a bound control (YES/NO)
to decide if the task is complete, i am still getting all the tasks changed
and not just for that single client.

can anyone please help me.

thanks

richard

 

[Linda Burnside]

Just to make sure I understand the problem you're describing, I'm going to
restate it. You click the check box on your form - a bound control which
indicates whether the task is complete or not - and when you click it, all
the checkboxes in your whole list appear as checked?

It sounds like your control is not bound. Double check the control source
for the check box.

Linda

 

[Dirk Goldgar]

hi,

i am trying to build a continious forms for task management within our
stsyem. there are several stages of tasks and a client can be at any
stage a particular time.

i want to be able to edit all of these tasks without needing to go
into each client.

the problem i am having is that even though i have a bound control
(YES/NO) to decide if the task is complete, i am still getting all
the tasks changed and not just for that single client.

can anyone please help me.

thanks

richard

I believe I saw this same question posted elsewhere, but the answer is
the same: if the control is actually bound to a field in the table, you
will not get the behavior you describe (unless you are executing some
code that modifies all the records). Therefore, you must be using an
unbound control, not a bound one. Bind the control to the field in the
table, and it should work the way you want.

 

[Guest]

Hi Dirk,

my control is defenitly bound, i am using some code to modify the next
action after update (either move to the next stage if complete or if not
change the forecolour to red and then change the date of the task due to +1
day, so that it appears in the next days tasks) ultimatly i will use a query
to select the records to be in the form based upon Date(), but i havnt set
this query yet as i wanted to make sure this part works first.

what am i doing wrong.

thanks
richard

 

[MacDermott]

Please check carefully.
Are all the checkboxes actually changing? Or are you seeing the forecolor
change on all your records? The latter behavior would be expected on a
continuous form.

 

[Dirk Goldgar]

Hi Dirk,

my control is defenitly bound, i am using some code to modify the next
action after update (either move to the next stage if complete or if
not change the forecolour to red and then change the date of the task
due to +1 day, so that it appears in the next days tasks) ultimatly
i will use a query to select the records to be in the form based upon
Date(), but i havnt set this query yet as i wanted to make sure this
part works first.

what am i doing wrong.

If you're changing properties of the control, such as ForeColor, then
that change is going to show up in all the records on the continuous
form, because there's really only one control for all records, just
drawn multiple times. Data changes, though, should be specific to the
current record.

If the ForeColor change is the only problem, then if you're using Access
2000 or later I suggest you see if Conditional Formatting can be used to
do what you want. That works on continuous forms, though it has a few
bugs.