Unlock Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a DB that is going to contain information of managers who are coming
to a conference. I has a field Name "Airport Transfer Required" this is a
combo box with a yes/no choice. I have another 2 fields which will store the
arrival and depature times

What i want is if the Airport Transfer field is No the time boxs to be
blanked out so they cant be edited, but if its changed to yes you can then
enter the times in the field.

Is this possible??

Also have another query along the same line. People attending need to
indicate whether they will be attending additional functions while at the
conference. I have have a table with the functions and there cost beside
them.

What i have here is a Tick box to say if they are attending. If its ticked
the cost is shown if not the field is left blank.

Is this also Possible??

I am only a noivce at Databases so will need clear instructions on what to do.

Thanks
 
Andrew,
There are several ways to code this, but this should be pretty straight
forward...

Using the AfterUpdate event of cboTransRequired...

If cboTransRequired = "No" Then
ArrTime.Enabled = False
DepTime.Enabled = False
Else
ArrTime.Enabled = True
DepTime.Enabled = True
End IF

Place this same code in the OnCurrent Event of the form.
 
Thanks works great

Al Camp said:
Andrew,
There are several ways to code this, but this should be pretty straight
forward...

Using the AfterUpdate event of cboTransRequired...

If cboTransRequired = "No" Then
ArrTime.Enabled = False
DepTime.Enabled = False
Else
ArrTime.Enabled = True
DepTime.Enabled = True
End IF

Place this same code in the OnCurrent Event of the form.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top