Beginner needs Combo Box help

This is an easy one. Lets say Control2 will be enabled or disabled (greyed
out and can't be modified) Based on a value in Control1. First thing is to
decide what the default is. If you want Control2 to be disabled until a
value is entered in Control1, set the Enabled property for Control2 to No in
design view; otherwise set it to Yes.

Then there are two places in your form you will need to address. Once is
the After Update event of Control1 where you can decide what to do to
Control2.


"serviceman via AccessMonster.com" wrote:

Thanks Klatuu,
As I'm reading your last post I have redesigned the table structure for my
scheduling, so that there will be no need to create tables on the fly. I am
going through the pains of building a calendar table (what fun; calendar data
was engineered by some people chained to a rock in the desert!
One thing I haven't quite figured out yet:
Can a field or control be 'grayed out" or disabled based on the current value
in another field or control? I don't want to give too much power to the
masses!
Andy

Klatuu wrote:
It has been fun. Glad to help someone who is so easy to work with.

One last thing regarding creating a table. If you plan to use a Make Table
query, be aware it guesses at data types, so you may not get exactly what you
want. It also has the bad habit of assigning the default field length to
every text field. As shipped, it is set at 255, so you will waste a lot of
space. You can change that in Tools, Options, Tables/Queries tab, but is
will still waste space or possibly truncate data. They way I handle this
situation is to create a table with the structure I want, then when I need to
put data in it, delete the data that is currently in it, then use and Append
query to load the new data.

Good luck with Access. As fast as you catch on, I am sure you will be a
star in no time.

Thats it! It works! Single quotes and your last code snippet did the trick!
Thanks so much for the advice and support; it goes a LONG way. My background
[quoted text clipped - 57 lines]
it out!
Andy

--
A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
Murphy

Message posted via http://www.accessmonster.com