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
-
Holly M
'Tasks to Apply' := 0
is the command to clear a reference field
-
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"
-
Holly M
I didn't use null but the number zero: 0
Does that work?
-
-
Well attention to detail helps and that was perfect, thanks!
Content aside
- Status Answered
- 2 yrs agoLast active
- 4Replies
- 90Views
-
2
Following