Need advise to make program user friendly

[Guest]

I am trying to make a user friendly selection form.
You are picking out your carpet for your home.
There is the Standard, Upgrade 1, Upgrade2 and Custom Options then
- you choose the manufacturer from a list of manufacturers then
- you choose the style from a list of style from manufacturers then
- you choose the color pertinent to that style and manufacturer then
- you choose standard padding or upgrade padding
- then you choose the room it is for from the floorplan

I would appreciate any advise on making this work easily.

 

[Van T. Dinh]

For the first 3 selections, it sound like you want to use a set of cascaded
ComboBoxes.

See The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm

There are similar articles in the Microsoft Knowledge Base:

http://support.microsoft.com/?adv=1