Verifying more than one txtbox has entries

[tigerdel]

Hi Guys

I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry

The code I have used for single entries is working fine but I can't get the dual entry to work

The codes I use are as below:

For the single entry

If cmbStatus.Value = "" Then
    MsgBox "You must add a Document Status", vbCritical
    Exit Sub

For the dual entry [which won't work] I used:

If cmbStatus.Value = "Approved" & txtApprover.Value = "" Then
    MsgBox "You must enter the name of the Approver", vbCritical
    Exit Sub

Any help gratefully received

Many thanks for looking

Derek

 

[dmt32]

Hi,
replace the ampersand & with And - see it this change resolves your issue

If cmbStatus.Value = "Approved" And txtApprover.Value = "" Then
    MsgBox "You must enter the name of the Approver", vbCritical
    Exit Sub

Dave

 

[tigerdel]

Wonderful - thank you so much