0

Button Code Help Please

What code would I use to make this button set the Location field to empty? The Location filed is a reference from table.

Screen Shot 2021-03-31 at 7.48.37 PM

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • One would think that writing the value "null" into the field would do the trick. Not so: to set a reference to empty, one must put the value "0" into the field.

    Like
    • Mr. K.
    • Mr_K
    • 1 yr ago
    • Reported - view

    OK, so what is the formula? Iv'e tried a bunch that don't work.

    Screen Shot 2021-04-01 at 7.58.12 AM

    Like
  • Location = 0

     

    Regards

     

    John

    Like
  • Sorry, thats Location:= 0

    Like
    • Mr. K.
    • Mr_K
    • 1 yr ago
    • Reported - view

    Thanks. That works.

    Like
Like Follow
  • 1 yr agoLast active
  • 5Replies
  • 317Views