Changing Text Box Color on a Form

[Carrie_Loos via AccessMonster.com]

I have an input form with repairs of certain assembly items. Within the form
is repair components that may be used in the repair of the assembly. Some
components are unique to a specific assy repair.

I am trying to cut down on input error with this form. One of the things I
want to do is start with a combo box with a specific list of items that can
be chosen. Once a specific item is chosen and the user leaves the box, I want
only those list of repair component fields I choose to change background
color.

Example:
Repair Item Combo List:
Brakes
Tires
Engines
Apolstry

Repair Components:
Brake Pads
Tire Repair
Spark Plugs
Leather
Engine Oil

So if I chose "Engine" the "Spark Plugs" and "Engine Oil" would turn a
background color lets say red while all other repair components would remain
the default color of white

Thanks for any help or suggestions

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

I am not sure that is possible with Access's combo box.

What is common is to use cascading combo boxes. With this method the second
combo box filters the records in the row source by a value in the first combo
box.

To see an example croll down to Cascading Combo Boxes Database at
http://www.utterangel.com/utterangel.aspx

Hope this helps ...

Boyd

I have an input form with repairs of certain assembly items. Within the form
is repair components that may be used in the repair of the assembly. Some
components are unique to a specific assy repair.

I am trying to cut down on input error with this form. One of the things I
want to do is start with a combo box with a specific list of items that can
be chosen. Once a specific item is chosen and the user leaves the box, I want
only those list of repair component fields I choose to change background
color.

Example:
Repair Item Combo List:
Brakes
Tires
Engines
Apolstry

Repair Components:
Brake Pads
Tire Repair
Spark Plugs
Leather
Engine Oil

So if I chose "Engine" the "Spark Plugs" and "Engine Oil" would turn a
background color lets say red while all other repair components would remain
the default color of white

Thanks for any help or suggestions

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com