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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Jim Evans" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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

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

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

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


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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Jim Evans" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> >
>
> .
>

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

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:(E-Mail Removed)...
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Jim Evans" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

ryguy7277,

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

Jim

"ryguy7272" <(E-Mail Removed)> wrote in message
news:E72B3C3F-B839-4253-8AB7-(E-Mail Removed)...
Maybe some of these links will give you ideas:
http://www.access.qbuilt.com/html/co...ormatting.html

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

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

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


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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Jim Evans" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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,

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

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:(E-Mail Removed)...
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Jim Evans" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>