In my opinion, FileDialog isn't perfect in any version of Access.
You're far better off using the all-API approach illustrated in
http://www.mvps.org/access/api/api0001.htm at "The Access Web". It has the
advantage that it's version-independent.
And yes, I'll acknowledge that it looks like a lot of code, but then you
have no idea how much code is hidden in the FileDialog control. All you need
do is copy everything that's in the shaded area between Code Start and Code
End and paste it into a new module (not a class module nor a module
associated with a form or report). You then need to write code like the four
line sample at the top of the page.