help with continious forms

R

richard harris

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
 
L

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
 
D

Dirk Goldgar

richard harris said:
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
Click to expand...

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.
 
R

richard harris

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
 
M

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.
 
D

Dirk Goldgar

richard harris said:
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.
Click to expand...

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.
 
L

Leonard Priestley

Your problem sounds as if you might be using a query which includes the
correct field, but the wrong table.

What I mean is that if you are using a lookup table with a key field of,
say, StudentID, your query needs to include the value of StudentID appearing
in whatever table is doing the looking up (tblStudentRecords let's say). So
that each record will have a different value. If you make the mistake of
putting the lookup table as the location of the field, then you will get the
same value in each record displayed, and I think that if you try changing
it, it will not only change in all the records displayed, but you will find
that your lookup table has had one or more values changed.

Hope this is helpful

Leonard Priestley
 
Top