Populate a sub form combo box based on a value from the main form combo box (1 Viewer)

[equus]

Hi everyone -

We recently upgraded and access 2010 adp database to and access 2013 accdb and not everything is working properly. We have a Form with a related Subform and they both have combo boxes on them. After a selection is made in the main form combo box, that value is saved in the table that the sub form is based on. (Was a Query, but the form doesn't show to add new records if used). The combo box on the sub forms is supposed to select the data that matches the field that was selected in the main form. No data is displayed. Check the table on Sql Server, and the value of that field is there. Have no idea why this is a challenge in Access 2013.
Code attached.

 

[CJ_London]

just a guess - do you requery the combo in the subform after doing your save? Or requery the subform?

Perhaps provide the code you use to do your updates, refreshes etc

 

[equus]

Ended up requiring the Main form after the selection in the combo box was made. That worked Thanks you! Still have to base the sub form on the table because when the query is used, the sub form doesn't show up.