0

How to clear/null a reference combo box

I've created a combo box/reference that will allow me to create tasks for a record from a list of selections. The field in the main record "Project" has a combo box called "Tasks to Apply" and when a user selects a record from the list, a number of tasks are created in another table. What I am wanting to do is clear/null the Combo box out since the tasks have been created, however there is no "field" that exists for the combo box, it is a table reference and any clue how to null out the combo box selection?

My task creation was baed on: http://software.kirknessassociates.com/blog_files/e7d4179b07c6bcb203ae50a5b26e828f-42.html

4 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    Holly M

    'Tasks to Apply' := 0

    is the command to clear a reference field

      • Holly_M
      • 1 yr ago
      • Reported - view

      RoSoft_Steven That is what I tried but since it is not a standard field (text, number, etc) and is a reference field the null doesn't seem to work. I've attach the screen image and you'll see the field name reference in the upper left matches but I get the dreaded "red"

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      Holly M 

      I didn't use null but the number zero: 0

      Does that work?

    • Holly_M
    • 1 yr ago
    • Reported - view

    Well attention to detail helps and that was perfect, thanks!

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 4Replies
  • 68Views
  • 2 Following