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

5 replies

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    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.

    • Mr_K
    • 3 yrs 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

    • John_Halls
    • 3 yrs ago
    • Reported - view

    Location = 0

     

    Regards

     

    John

    • John_Halls
    • 3 yrs ago
    • Reported - view

    Sorry, thats Location:= 0

    • Mr_K
    • 3 yrs ago
    • Reported - view

    Thanks. That works.

Content aside

  • 3 yrs agoLast active
  • 5Replies
  • 341Views