There is a combobox based on a table of facilities. I made a datasheet form of the table and placed a link to it on the form with the combobox. So far so good. But I can't seem to figure out how to requery the combobox when the facility editing form is closed. I tried using
I found a keyboard tip from Tech Republic's Mary Richardson that said to use Shift F9. That works, so it seems like there must be a way to trigger the Requery method in vba.
I think I found it. I put that same line in the list editing form's AfterUpdate and that seems to requery the combo on the original form. I notice that after a deletion it shows '#Deleted' at first, but after another edit that goes away and it does accept new data. I'll keep checking it to be sure.
But I also have a follow up question now. Since I use this same list on more than one form, when the list-editing form is called, I want to pass the name of the calling form with OpenArgs. Unfortunately, I can't see how to integrate the string form name into the code line: Forms![OpenArgs]!cmbFacility.Requeqry.