I guess I am not making myself clear.

I have a data environment in Visual Basic called dbfDataEnv. I can open the designer and look at the tables, browse them, see the contents of the fields.

It is connected to my form via dbfConn.

My vfp database, projdbc, contains a table, cmdlist, with a field, cmnd.

I would like to place the field value in a private variable, tmpcmd, so that I can then do some manipulations on that variable. Neither the field or the variable are associated with any objects on the form. The things I want to do with the variable would be completely behind the scenes, unknown to the user.

I define tmpcmnd in the form load section with the following statement:
dim tmpcmnd as string

I just can't seem to get the syntax right on this to place the value of the field cmnd located in table cmndlist into the variable tmpcmnd.

I have tried syntax such as the following:

tmpcmnd = dbfDataEnv.dbfConn.cmdlist.fields("cmnd")

or

tmpcmnd = dbfDataEnv.dbfConn.cmdlist.cmnd

Neither works.

I have also tried:

set tmpcmnd = dbfDataEnv.dbfConn.cmndlist.cmnd

That doesn't work either.

I have combed the texts available to me. There are no examples that seem to fit my situation as most are pulling the from cursors created by sql statements as a command in the dataenvironment rather than looking directly into an existing table.

Any help would be appreciated. Thanks.