Using one form to populate a color in another form??

  • Thread starter Thread starter james
  • Start date Start date
J

james

I am using Access 2000 and I am sort of a newbie.

In Excell I would know how to do this using the If function. In Access I
can't figure it out, so any help is greatly appreciated.

I have a form called CustRecord that has two fields, one called StartTime
and another field called EndTime.

I have another form called Calendar that has fields named from 8.00am to
5.00pm in increments of .30.

I would like this to happen: When StartTime is filled in with a time, say
8:00am and the EndTime is say, 11:00am I would like the fields on Calendar
from 8.00am to 11.00am to fill in with a color, such as red, blue whatever.

Can this be done?

Thanks in advance for any input.

James
 
I took a class on Access. I was trying to us the IF
statement in Access (because I'm used to using it in
Excel) and I coudln't get it to work. I asked my
insturctor and he told me to use IIF and it worked. IIF
in Access should be the same as IF in Excel (the rest of
the syntax for IIF should be the same as using IF in
Excel.)

I hope that helps.

Conan Kelly
 
Back
Top