<< 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, the Query object tries to remove the field informed in the FieldName parameter in the first table found on the database. |