combo box blank

[Dave14867]

smg,



The duplicates in the date field are because of the way the data is in the tables is structured, it's pulling every table entry, that is why, if it were me, I would restructure the tables. With that being said, the "Officer" Combo Box should only list the Officers that had an "Assessment" on the date chosen. Make sure your using the Grayed out combo boxes, not the original ones.

Dave

[Dave14867]

smg,

I added a new combo that allows the user to select from all entries in the assessment table and they can see all data for each entry, and I made the other Combo's invisible to prevent confusion. Keep in mind, at this point, nothing in the rest of the form gets updated based on the selection.

CONOPS Assessments-2.zip

Dave

[smg]

I like that option thank you. However, my goal is to filter for all assessments by date or filter for all assessments by officer. If the answer is restructuring tables to get to this end result, would you please tell me how you would restructure in order to get distinct dates in a combo box so that I could filter the form for assessments on a specific date? Let's work with getting to all assessments on 03/21/19. I really appreciate your assistance

[Dave14867]

smg,

I am not sure if that can be done with a combo box with the current structure, maybe someone else can chime in on that, many have come up with ways of getting things done that I wouldn't have been able to get accomplished.

I will see about modifying some tables to see if I can get you what you want.

Dave

[Dave14867]

smg,

I think I may have what you want, and it may be able to be done in your original file. Take a look at the attached file, you pick a date, then select the officer drop down and you get a list of the officers that had an assessment on that day.


CONOPS Assessments-22.zip

Dave

[smg]

That works and I will see if I can get it to update the rest of the form. Thank you so much!

[davegri]

CONOPS Assessments-22-davegri-v01.zip
See if this is more like what you want. for the date and officer comboboxes it uses filters instead of findfirst.
So when you select an officer, it will restrict the form to ONLY that officer.
When you select a date it will restrict the form to ONLY that date.
When you select a date and an officer, it will restrict the form to ONLY that officer on that date.

[smg]

Yes yes yes, this is it! Thank you so much, I do so appreciate!!

[davegri]

And if you want to turn off the search and show all, add a button in the header with this event:

Private Sub cmdShowAll_Click()
    Me.CboSelectAssessmentDate = Null
    Me.cboSelectOfficer = Null
    Me.FilterOn = False
End Sub