Pick Year & Update Combobox which Updates form

[warmanlord]

Ok, I will create a backup copy of my DB and shoot it over to you, I was off yesterday, so sorry for the late response.

[warmanlord]

Here is the DB, i took out any information that is confidential. What I been trying to do is as follows. On the video form it is used to add in information to the DB, at the top I had a pick Video Number Combobox. The box worked fine to bring up any records once you selected the record you want so that you can update the record. What I was trying to accomplish past that, I was trying to plan for future growth of the DB. The combobox was great that is listed the values of the Video Number or you could type in the Video number and it would bring up that record, but as the years go by and we continue to use the DB, the combobox will become over saturated with data, so I was attempting to limit the choices in the combobox by having another combobox state each year, 2015, 2016 etc as a list combobox. I want to take 2015 and have it limit the selection in the video number combobox to all records that contain 2015 in it. Since Video number is V-1-2015 to V-5-2015 and so on. Thanks again for the help.

[June7]

Don't know why the VideoNumber combobox is not working, maybe corrupted. Seems I've encountered this before.

I created a new combobox with the same RowSource and used its GotFocus event for the Requery code. This works.


The embedded macro in the VideoNumber combobox won't work because the ID field is not included in the RowSource.

Change properties:

RowSource: SELECT ID, [Video Number] FROM VideoCameraInformation WHERE [Video Number] LIKE "*" & [SelectYear_cbo];
ColumnCount: 2
ColumnWidths: 0";1"

[warmanlord]

Yep, that was all it needed, Select ID, once I added that into the row source, it seems to work. Thank you for all that, it is really helpful. Now time to go watch some more videos on coding and such to increase my knowledge of it. Thanks again for the help.