2 Questions with Continuous Forms

J

Jason

I have a continuous form showing multiple projects. There is a command
button on each line that takes the user to a screen that shows the different
subprojects that need to be completed for that specific project and allows
them to sign out any of the multiple sub projects. Multiple people can sign
out the subs. In other words if a project has 10 subs you can anywhere from
1 to 10 people working on them. So here are the questions.

1. When all 10 subs have been signed out I would like to disable the sign
out command button on the specific row on the continuous form. I have
created a field in the underying table that keeps track of whether or not a
project is completely signed out, but when I use that in the open form event
it disables every single command button on the whole continuous form.

2. Similar to number 1. I also have on my continuous form a label that
shows who has their names in the signout (i.e. Form_Open Me.lblNames.Caption
= sub1Name & "/" & sub2Name...). It's a little more complex than that but
that's the idea. The problem is that when the form opens the exact same
names are displayed on every row of the form. How can I get each row to use
the information from it's own row?

Thanks for any help!
 
N

nickmcd

Jason,

I have just been reviewing your posting and I am encountering a similar
problem. I have also created a field (Invoiced_Check) whose value is 1 if all
subrecords are complete and is 0 (zero) if they are not. I would like to
disable a button on the continuous form for only the record(s) where the
Invoiced_check field is zero.

Currently, any code I have entered either enables/disables all buttons
regardless of the record. It would be much appreciated if you could advise
how you overcome this.

Regards,

Nick
 
V

Van T. Dinh

What you see is many instances of the *same* Control (CommandButton). All
instances will be either all enabled or all disabled and you can't set some
instances enabled and some others disabled.

--
HTH
Van T. Dinh
MVP (Access)
 
Top