I have a command button in a form. The button should open the dialog box of "Insert Picture" (like in Microsoft Word when I click on the menu "Insert/Picture/From File"), pass that picture to an image control and the path to a text box. It has to be done in VBA, but i don't no how.

Can anyone help me.

Check out this code. Its not exaclty what you want, but it will open the standard File>Open dialog. You can restrict the search to image type files. The only thing I'm not sure how to do is force the view to thumbnail mode.

The code returns the path to the image file whihc can then be used to populate a text control and the Picture property of an image control.

HTH

Hi,
search UA. There have been many discussions on exactly this e.g.:
earlier discussion
HTH
Good luck