Data Control and the '!'?

[hozo]

WhaZzZZZzzzzZup fellow progy's

What's up with this ! directive? I see it however I do not seem to be able to master it :)

Aparently you can directly access fields via the header/field title of the current record using !?
Can this be done with the data control? I tried some combos and I can't find souce because searching by '!' anywhere does no good :)

This is what I'm trying..
iCust_Num = customerDBF.recordset.fields!CUST_NUM

ps. i'm working with a foxpro db.. hence I have the data control to do most of the opening work for me..

Thanks guys.

[Edneeis]

You do it from the recordset to return the field.
ADO!PtId=43
would set the PtId field to 43 in the ADO recordset
Or x=ADO!PtId would make x equal the field value

Using a data environment it would look like:

dataE.tblPatients!PtId=43
And so on and so forth hopefully that will help you

You can also use:

Msgbox Data1.Recordset("PtId")
To get the value