ComboBox options

[dylcon]

So I have gotten rid of all of my lookups and I am trying to cascade the combobox once again, but it is still not working. What I want to happen is that once the 'CustomerNamecbo' is updated, I would like the 'PartNumbercbo' to requery accordingly. It keeps asking me to enter parameter values once I click on 'PartNumbercbo'

Private Sub CustomerNamecbo_AfterUpdate()    
    Dim strSource As String
    strSource = "SELECT ActiveParts.PartNumber, ActiveParts.PartNumber " & _
                   "FROM ActiveParts " & _
                   "WHERE CompanyName = '" & Me.CustomerNamecbo & "' ORDER BY ActiveParts.PartNumber"

    Me.PartNumbercbo.RowSource = strSource
    Me.PartNumbercbo = vbNullString


End Sub

[rzw0wr]

I usually don't us VBA for my combo boxes.
I will add the SQL into the row source and use the where clause to reference the previous combo box.

Your method is good also. Same thing, just different.

"WHERE CompanyName = '" & Me.CustomerNamecbo & "' ORDER BY ActiveParts.PartNumber"

Is CustomerNamecbo text? remember you are looking at the bound field in a combo.
Take a look at the CustomerNamecbo and make sure the first field is text and not the ID of the record.



Dale

[dylcon]

It is the ID of the record. Does that mean it will not be possible to do?

[dylcon]

I know this is an older thread, but I have done a lot more on my database and I have come back to the same problem with cascading comboboxes repeatedly. None of the resources provided have allowed me to accomplish my goal and I am wondering if my relationships setup is limiting how my combo boxes will work. If anyone can help me out with this, I would be very appreciative. Here is my file, just in case anyone wants to look for themselves. It is on the incoming form and I have tried running the commands in VBA and with SQL in the row source, but nothing has worked. I am trying to get the CustomerName (first combobox) to limit which PartNumbers are available for selection (second combobox). Or if there is another way to do this, that would be great as well. Thanks in advance!

New Compressed (zipped) Folder.zip

[pbaldy]

Continued here apparently:

https://www.accessforums.net/access/...one-35478.html

[rzw0wr]

dylcon, I just answered this in your other thread.
Maybe you should close this one.

Dale