Here is the code for my open file dialog:

Private Sub Open_Click(Index As Integer)
On Error GoTo ErrHandler
'set filters
CommonDialog1.Filter = "DBF (*.dbf)|*.dbf"
'display file open box
CommonDialog1.ShowOpen
Data1.DatabaseName = CommonDialog1.filename 'sets database as selected file

Text2.DataField = "MARKET" 'this is the name of the field i want to pull

frmGlobal.Refresh

ErrHandler:
Exit Sub

End Sub

In the options for text2 the datasource is set as data1.

when they open the file the value in "MARKET" does not show up in the text box.