How do I Use Cascaded Filters

[dgaletar]

{Moderator Edit}
I have moved this hijack post to a new thread. Please do not take over an existing thread with your own questions as this is a punishable offense.
The original thread, from where this was originally taken, can be found at how to filter list of items in a combo box by selecting items in another combo.
{/Moderator Edit}
Hey guys... it's me again! I'm stuck on this one also. I have read both of your articles, and must say that both are very detailed and well written... thank you.

I found, though, that the article written by Rabbit more closely reflects my situation. My problem is that I am trying to use the first combo box for them to select the Department, and the second for them to select the truck number from that Department (CUA#). Both details can be found in the same table - VEHICLE DETAILS : Table.

Here is the code I am using:

Private Sub Combo14_Click()
    With Me![CUA#]
        If IsNull(Me!Department) Then
            .RowSource = ""
        Else
            .RowSource = "SELECT [CUA#] " & _
                         "FROM VEHICLE DETAILS : Table " & _
                         "WHERE [CUA#]=" & Me!Department
        End If
        Call .Requery
    End With
End Sub

I'm getting "red flagged" on the "Else" statement (see attached Screenshot 1.

The form (named "Department List : Form") is visible in Screenshot 2, and the layout of the table is visible in Screenshot 3.

Thanks!

[Seth Schrock]

My guess is that the error is in your FROM clause. If the name of your table is "Vehicle Details : Table" then you need to put it inside brackets [] to be

FROM [Vehicle Details : Table]

[NeoPa]

Dgaletar,

This question has been answered fully. If you have further problems then please post a new question properly with the relevant details included. You also have the option to link to an existing thread if you believe that will help. Please make sure the question posted makes sense on its own though, without the need to visit the linked thread to make sense of the question (EG. Don't post a question simply asking for help with code found in another thread). You may find the following links helpful on that score :
Before Posting (VBA or SQL) Code.
How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!.
POSTING_GUIDELINES: Please Read Carefully Before Posting to a Forum.

Dgaletar:
I have read both of your articles, and must say that both are very detailed and well written... thank you.

Thank you. You go on to say you found Rabbit's article more related to your question. That is fine, but leads me to assume you perhaps didn't understand the Cascaded Form Filtering very well though. I believe it covers your scenario fully, but then it's always easier to see things from a position of experience.

To make it very clear - any further question or answer posts related to any further questions (other than the original one of the thread) that are posted in here are very likely to be deleted.