Access 2016 Cascading combo boxes

[RCBricker]

Hello all,

I am building a form which will allow the user to add new claims. Two of the combo boxes are based on the same query.

What I would like to do is when they select the providers name from the first combo box, that the second combo box is populated only with the ID #s associated with that provider.

I have looked on line and found basically the following...

Cmbo_Provider_ID.RowSource = "Select Provider ID " & _
        "FROM tbl_CLAIMS Query " & _
        "WHERE Provider Name = " & Cmbo_Provider_Name.Value & "ORDER BY Provider ID"

but I get an error when trying it out.

Error:

Syntax error (missing operator) in query expression 'Provider ID'.

 

[RCBricker]

NM I figured out my error.

aside from missing [] for table and field names with spaces, the Cmbo_Provider_Name.Value is text and needed some ' around it.