This is the scenario:

* The user clicks an "Add new record" CmdButton next to the List / ComboBox
* The style is set to Combobox
* Focus is transferred to the Combobox
* Rowsource is set to ""
* User types in a new value or does something else

* The valid clause fires
*

WITH THIS
  IF EMPTY(.ROWSOURCE)          
    IF NOT SEEK(ALLTRIM(.DISPLAYVALUE),"CollectionSets","Collection")
      INSERT INTO CollectionSets (CollectionSet) VALUES (.DISPLAYVALUE)
    ENDIF
    .STYLE= 2
    .ROWSOURCE="CollectionSets.CollectionSet"
  ENDIF
ENDWITH

For some reason, setting the Format and/or Inputmask properties to ="@!TAAAAA"
does not work.

It works fine on the table, so does this mean no rowsource - no validation?

Is there a workaround or am I just being stupid?


TIA