I have previously posted this question to another forum but haven't gotten any responses. I understand I should link between the 2. So think link is to my post on the ozgrid forum.
The macro starts from a form button action, with a bunch of queries to external databases, it's last action is to run a bit of VBA that appends a few lines to a txt file.
When it runs, all is well up to this open Module command, where it only opens the vb editor to the starting line of the procedure. I am forced to hit play. When I do click play, the sub routine runs without issue.
I am not sure why it requires my interation to run. This feels like Access has trust issues and won't commit to me . I figured it was a macro security setting or trusted location issue but I think I have set that correctly.
Once I have the location in the list of trusted locations what else should I be checking.
I'm totally self taught so I hit the wall on newb stuff all the time.