Form Control Help Please.

[Guest]

I have a form broken out into four sections, the data is held in one table.
What I want to accomplish is for each of sections to be visable and disabled
while the preceeding section has null fields. Example: when the first
section is filled in, the second section will be enabled for data enty, and
so on for the remaining sections.

What is the best way to accomplish this?

Thank you,

 

[Jeff Boyce]

Consider taking a look at using a tab control, hiding the 'tabs', and using
your own <Next>, <Back> command buttons to move from tab control page to
page. You can make it look/act a lot like a wizard (which may be a
trademarked term ... <g>).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks Jeff, sounds like a great alternative, unfortunately the end user
wants to see all the sections on one form. Any other options?

 

[Jeff Boyce]

Start out with all but "section1" controls disabled. After enough of the
controls in section1 have been filled in, enable section2 controls. Rinse &
repeat...

Regards

Jeff Boyce
Microsoft Office/Access MVP