I have a parent form with a combo box to search records. Within the parent is the 1st sub form. There is also a second sub form within the 1st sub form.
When select a record on the parent form, the sub form combo boxes do not update with the main form.
I can get this working if I use refresh all, or use the refresh command on "got focus" event. The only problem with this is you need to establish focus first then click combo box for it to update. All the sub forms have been linked with child and master fields. Not sure sure what I could be missing to fix this problem.
Any help would be appreciated.
Thanks