RemoveField

<< Click to Display Table of Contents >>

 

RemoveField

RemoveField(FieldName, [Table])

This method removes a Field previously included in a Query. The FieldName parameter determines the name of a Field to remove. The Table parameter represents the name of the table to which this Field belongs. The next script contains an example of using this method.

Sub CommandButton1_Click()
  Screen.Item("E3Browser").Item("Query")._
    RemoveField "Field1"
End Sub

 

NOTE

If the Table parameter is omitted, a Query object tries to remove the Field informed in the FieldName parameter in the first table found on that database.

Was this page useful?