Ken Getz's GetOpenFile as Posted on Dev's site
Hello,
I made the switch to the code offered at Dev's site and originally authored
by Ken Getz, specifically the API Call for standard Windows File/Open Save
dialog box. This is very nice code, but alas, I being a far less
sophisticated coder have an issue in the instances that I am using this code
which is
Private Sub FindFile_Click()
Call GetOpenFile
Me!MyFile = GetOpenFile
End Sub
where MyFile is set to an unbound text box object in a form and the code is
attached to a command button. When I click on the commnad button, the code
correctly brings up a window where I can select a file. After selecting the
file and clicking "open", the window closes and opens again. The second
time I select the file and the file path and name are correctly displayed in
the MyFile object.
Why does the window open twice and only retain and update the file selection
the second time?
tia
Moira