I have a button on a form (from 6 -> X) that opens a visible form on a different database that was previously opened secret, so I can work with some data, then a button on that form executes MakeSecret so it disappears again but is available for lookup reference, etc. In my PanX version, nothing I do will make that form come up. A simple “File>Open” does nothing visible, without error, presumably because it knows that database is already open? Pushing the button, or Run or Step in the procedure window also does nothing. This is the code the button executes:
OpenFile "UserPreferences" GoForm "UserForm" Find Username=UserMe
UserMe is a fileglobal that is previously defined, identifying the current user. I tried this with “OpenDatabase” in the first line, but no difference. I put a message statement at the beginning of my procedure and it fires; I put another message statement at the end of it and it never fires. In fact, I put a message statement after each of the 3 lines of code, and it looks like none of the code executes, I only see the initial message. What’s going on?
UPDATE: Using Find & Open, I can “Open Data Sheet Only” so I can work with my data, and I can open my form at this point, but I can’t just “Open Database” and in the long run this isn’t a satisfactory path for my users to have to take.