Search results

I know this is an old thread, but it helped me and I wanted to save it to my discussions and commenting on it was the only way I knew how :)

It didn't work actually. I wasn't paying attention to enough detail I guess. When I select an agent, the list box refreshes to only that agent's clients. Thats perfect. if I then choose a county for that agent and that agent has clients in that county, it reduces the list to that agent and...

That worked!!! Wow!! I followed a different sample code and am quite impressed with myself that I figured out how to apply it to what I needed. Now that I have these two combo boxes, is there a way to get the second one to reset to "blank" if the firs tone--the Agent is changed?

I actually managed to get one combo box to work using this code: Private Sub cboAgent_AfterUpdate() Dim strSQL As String Dim strWhere As String strWhere = "WHERE fkAgentID=" & Me.cboAgent & " " strSQL = "SELECT qryClientListBox.ClientLastName, qryClientListBox.ClientFirstName...

Hello all. I am not sure if this is a forms question or a queries question. Probably a bit of both. I saw this idea in a book but can't take it from a simple example to my more complex example. And I have been at it for a long while. :banghead: access 2007 is my version, btw, a very...

Hello All! I am new to Access and "volunteered" to help a friend with a small insurance create a database for their 3000 clients when the unmanageable spreadsheet they were using finally crashed. I have now purchased 5 books and spent many hours googling and reading. I am now 3 months...