Cycle through field on form through VBA

[gmazza via AccessMonster.com]

Hey there,
How and where do I cycle through each field in each record on a form through
VBA?
I have a continuous form, and depending on data in a table, compared with the
current record on the form, I either want a combo box with a list of values
to show up, or a tex box where the user can enter a value to show up.
Problem is, either a combo box shows up for ALL the records, or a text box
shows up for ALL the records in the coninuous form. I want the proper box to
show up depending on the record I am on.
Any help is appreciated!~

 

[Beetle]

I don't believe you can do that. A continuous form is
essentially one row of controls repeated over and over
with different data. Any design changes in the row are
automatically going to be reflected in *all* rows in
form view.

 

[gmazza via AccessMonster.com]

Even if, depending on data in the table you make 1 field visible and another
invisible? It still affects EVERY row? Is that right? Is there no work around
or way around it?

I don't believe you can do that. A continuous form is
essentially one row of controls repeated over and over
with different data. Any design changes in the row are
automatically going to be reflected in *all* rows in
form view.

Hey there,
How and where do I cycle through each field in each record on a form through

[quoted text clipped - 6 lines]

show up depending on the record I am on.
Any help is appreciated!~

 

[Beetle]

I don't believe so. You can use Conditional Formatting to
control things like fore color/back color to a certain extent,
but what you're talking about is a change in the graphical
design of the form. I don't see any way to prevent that
from affecting every row on a continuous form.

--
_________

Sean Bailey

Even if, depending on data in the table you make 1 field visible and another
invisible? It still affects EVERY row? Is that right? Is there no work around
or way around it?

I don't believe you can do that. A continuous form is
essentially one row of controls repeated over and over
with different data. Any design changes in the row are
automatically going to be reflected in *all* rows in
form view.

Hey there,
How and where do I cycle through each field in each record on a form through

[quoted text clipped - 6 lines]

show up depending on the record I am on.
Any help is appreciated!~