Form command button to do something/call function

[shubhamgandhi]

I have created a basic form in access that has a couple of buttons and text fields. I want the button to do something along the lines of when I click it, it should bring up a browse file dialog and when I select a file, change the text field to the path of the file.



My question is how can I program this? Specifically, do I create a module that goes like?

sub command1_onClick()
  ...bla bla...
end sub

Or are forms programmed differently? How can I tie a function to a button?

[pbaldy]

See if this gets you started:

http://access.mvps.org/access/api/api0001.htm

[shubhamgandhi]

I was able to sort of get it working another way:

Private Sub browseDataButton_Click()

    Dim dlg As Office.FileDialog

    Set dlg = Application.FileDialog(msoFileDialogFilePicker)
    
    dlg.Title = "Select Excel Spreadsheet to import"
    dlg.AllowMultiSelect = False
    If dlg.Show = -1 Then
        dataPath = dlg.InitialFileName
        MsgBox dlg.InitialFileName
        Me!browseDataPath = dlg.InitialFileName
        
    End If

End Sub

I'm able to get the directory where the file is, but does not append the name of the file to the directory.
For example if blabla.xls is on the C drive, MsgBox will popup "C:\".
How do I make popup "C:\blabla.xls" (or whatever the xls file may be for that matter)?

Thanks