Roland,

That would be (assuming Row 0):

Dim iFileNum as integer
iFileNum = Me.Listing01_Client_Ds11.Tables("Client").Rows(0)("FileNum")

~~Bonnie


>Hi,
>
>How do you retrieve a value from a column in a dataset?
>
>Tried the following and it does not pass the syntax checking.
>
>Dim iFileNum as interger
>iFileNum = Me.Listing01_Client_Ds11.Tables("Client", "FileNum")
>
>Thanks
>Roland