#1 Today, 08:07 AM

M

mahoney

Joined
Mar 1, 2009
Messages
1
Reaction score
0
Hello,

I have a form which includes the following fields,
Dispatch Method (Combobox)
AWB (Text Box)
Tape Format (Combobox)

Dispatch Method has the following choices; DHL, FEDEX, UPS, Sky Net, Satellite & Email.

I want "AWB" and "Tape Format" to be disabled when I choose "Email" as "Dispatch Method", and enabled when I choose any of the other
Also I want "AWB" (only) to be disabled when i choose "Satellite" as "Dispatch Method"

I have tried the If Then and it did not work, i also tried the following Select Case code (I assume it is better in this case)

Private Sub DispatchBy_AfterUpdate()
Select Case DispatchBy
Case "Aramex"
AWB.Enabled = True
TapeFormat.Enabled = True
Case "DHL"
AWB.Enabled = True
TapeFormat = True
Case "Email"
AWB.Enabled = False
TapeFormat.Enabled = False
Case "FedEx"
AWB.Enabled = True
TapeFormat.Enabled = True
Case "Satellite"
AWB.Enabled = False
TapeFormat.Enabled = True
Case "Sky Net"
AWB.Enabled = True
TapeFormat.Enabled = True
Case "UPS"
AWB.Enabled = True
TapeFormat.Enabled = True
End Select
End Sub

I also disabled AWB and TapeFormat in the on current event


But still not working well,

Help Please

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is it possible to ask a question within a question? 0
Combo box opening non-visible subfrms on tab control 7
Not in List Event 1
seting focus 2
Custom Images not showing in Ribbon toggle button 2
How to enable or disable fields based on value of a combo box 1
Runtime Error 3001 Arguments Are Of The Wrong Type, Are Out Of TheAcceptable Range, or are in confli 4
Reset Form to show default values 1

Top