HELP: I want a message when the 2nd combo in a cascade...

doesn't produce any options to choose from.

It has been suggested that I use the form current event which does make sense.

I don't know what the code is.

Your subject line is too long to display. Post back with your question in
the body of the message.

"scubadiver" wrote:

doesn't produce any options to choose from.

It has been suggested that I use the form current event which does make sense.

I don't know what the code is.

When the user choose a customer I want a message to tell the user that the
current branch address is the only address available.

The only thing you told me before is what event to use, not what code to use.






"Klatuu" wrote:

Your subject line is too long to display. Post back with your question in
the body of the message.

"scubadiver" wrote:

doesn't produce any options to choose from.

It has been suggested that I use the form current event which does make sense.

I don't know what the code is.

Presumably you've got code in the AfterUpdate event of the first combo box
to reset the RowSource for the address combo box. Once you've done that,
check the value of the address combo box's ListCount property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"scubadiver" wrote in message
...

When the user choose a customer I want a message to tell the user that the
current branch address is the only address available.

The only thing you told me before is what event to use, not what code to
use.






"Klatuu" wrote:

Your subject line is too long to display. Post back with your question
in
the body of the message.

"scubadiver" wrote:

doesn't produce any options to choose from.

It has been suggested that I use the form current event which does make
sense.

I don't know what the code is.

Scubadiver,

Use the ListCount property of the 2nd combo box to determine the number of
listings:

If Me![YourComboBox].ListCount = 0 Then
MsgBox "There are no choices for this customer."
End If

The code should also go in the AfterUpdate event of the first combo box.

Hope that helps.
Sprinks


"scubadiver" wrote:

doesn't produce any options to choose from.

It has been suggested that I use the form current event which does make sense.

I don't know what the code is.

In the After Update event of combo 1:

Me.Combo2.Requery
If Me.Combo2.ListCount = 1 Then
MsgBox "Only one address found"
End If

"scubadiver" wrote:


When the user choose a customer I want a message to tell the user that the
current branch address is the only address available.

The only thing you told me before is what event to use, not what code to use.






"Klatuu" wrote:

Your subject line is too long to display. Post back with your question in
the body of the message.

"scubadiver" wrote:

doesn't produce any options to choose from.

It has been suggested that I use the form current event which does make sense.

I don't know what the code is.