Continuous forms problem

[Jim Evans]

Is it possible to control properties, such as Visibility, on each row in a
conrinuous form?

For example, I have ComboA and ComboB. Can I control the Visibility of
ComboB based on the selection made in ComboA for each row of a continuous
subform?

TIA for your input.

Jim

 

[Douglas J. Steele]

Not really. While it may look as though you've got, say, 25 instances of
ComboA and 25 instances of ComboB, in actual fact you've got one instance of
ComboA and one instance of ComboB, repeated 25 times. That means when you
make a change to the visibility, it will affect all 25 rows.

You might be able to do something with Conditional Formatting.

 

[ryguy7272]

Maybe some of these links will give you ideas:
http://www.access.qbuilt.com/html/conditional_formatting.html

Here's a continuous Form:
http://www.databasedev.co.uk/conditional_formatting.html

http://blogs.techrepublic.com.com/msoffice/?p=257

http://www.blueclaw-db.com/download/conditional_formatting.htm


Here's a Report (obviously, different from a Form, but you get the idea):
http://www.databasedev.co.uk/conditional_report_formatting.html

 

[Jim Evans]

Thanks, Doug. I'll take a look at trying conditional formatting, but, how do
I specify which of the forms it should effect? IOW, how do I refer to a
particular instance of the form in the entire continuous form?

Jim

Not really. While it may look as though you've got, say, 25 instances of
ComboA and 25 instances of ComboB, in actual fact you've got one instance of
ComboA and one instance of ComboB, repeated 25 times. That means when you
make a change to the visibility, it will affect all 25 rows.

You might be able to do something with Conditional Formatting.

 

[Jim Evans]

ryguy7277,

Thanks for the links. There is some very good information and suggestions at
these sites.

Jim

Maybe some of these links will give you ideas:
http://www.access.qbuilt.com/html/conditional_formatting.html

Here's a continuous Form:
http://www.databasedev.co.uk/conditional_formatting.html

http://blogs.techrepublic.com.com/msoffice/?p=257

http://www.blueclaw-db.com/download/conditional_formatting.htm


Here's a Report (obviously, different from a Form, but you get the idea):
http://www.databasedev.co.uk/conditional_report_formatting.html

 

[Jim Evans]

Douglas,

Thanks for the info. I understand what you are saying about the controls
being viewed by the form as 1 of each control. It's a shame that MS doesn't
give us more flexibility with continuous forms and their controls.

Thanks,
Jim

Not really. While it may look as though you've got, say, 25 instances of
ComboA and 25 instances of ComboB, in actual fact you've got one instance of
ComboA and one instance of ComboB, repeated 25 times. That means when you
make a change to the visibility, it will affect all 25 rows.

You might be able to do something with Conditional Formatting.