Hello All,

Below I have a Select Case statement.  All is well except when there is No
Data in a particular query then the form blanks out and you can't even make
another selection.  I would like to create a message and then have the form
remain available to make another selection.  No matter what I try I can get
a message, so perhaps I am not doing it right.  Any ideas???

Select Case cboDocumentName
       Case "Got Your Referral"
           Me.RecordSource = "qryGotReferral"
           Me!cboCustomerID.RowSource = "SELECT qryGotReferral.CUSTOMERNBR,
qryGotReferral.NAME FROM qryGotReferral GROUP BY qryGotReferral.CUSTOMERNBR,
qryGotReferral.NAME;"
       Case "No Rewards Letter"
           Me.RecordSource = "qryNoReward"
           Me!cboCustomerID.RowSource = "SELECT qryNoReward.CUSTOMERNBR,
qryNoReward.NAME FROM qryNoReward GROUP BY qryNoReward.CUSTOMERNBR,
qryNoReward.NAME;"
       Case "The Money Letter"
           Me.RecordSource = "qrySold"
           Me!cboCustomerID.RowSource = "SELECT qrySold.CUSTOMERNBR,
qrySold.NAME FROM qrySold GROUP BY qrySold.CUSTOMERNBR, qrySold.NAME;"
   End Select

Thanks for any help you can give...
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II