Sequence of forms based on Checkboxes?

[Scottie]

G'day everyone,

I'm relatively new to access and have been using these forums to help me learn quite a bit already, so Thanks for everything so far!

As far as I have looked, I can't find help with this particular issue I have found myself in.

I'm trying to create a registration database where a single company can register more than one type of service, and the forms are run in a sequence as particular fields need to be entered before they can proceed.

I was hoping to be able to select which forms of service types appear after they have entered their companies details based on a selection of checkboxes that they select.

eg: 'Company A' only supplies service 1, 2 and 5 out of 6 possible services, so when he presses the proceed button at the end of the current form, only the forms for the services he selected appear, also in sequence (as they also have required fields).

I hope that's not too confusing! It seems a little complex but possible with a little tweaking from some coders?

Thanks for any help in advance!

Scottie.

 

[Dennisk]

you may find it easier to use tab pages. With a form on each page. Develop a combo box that list all your companies and in the after update event use a select statement to enable/Disable the appropriate group of tab pages.

 

[MStef]

Look at "DemoServiceA2000.mdb".
Look at Tables,Forms.
Open "frmCompanyMain" and try.
Adapt it as you need.

 

[Scottie]

Thanks guys,

I was able to get this going by using IF Statements to get the check box results and enabling the appropriate buttons in a switchboard as required.

Cheers,

Scottie.