I have a value list that is created via a table.

The user needs a way to set the value back to nothing (null), after accidentally selecting a value from the dropdown list.

How do I do this? I don't want to add a fake record to the table - and even then, the dropdown wouldn't be putting a null value back in that field... I can't allow them to type into that field (and therefore, be able to blank it).

(This problem is related to my post:

http://fmforums.com/forum/showpost.php?post/295804/)

I'm hoping this is an easy question, and everyone will jump at the chance to give me that easy answer. :

Thanks,

Joni

Edited July 2, 200817 yr by Guest
added link to post with more background info on issue

You can put a button on your layout with a simple script attached

setfield(yourfield;"")

That will empty your field of any contents

hth

Phil

Good idea. And nowadays you don't even need a script, the button can run script steps directly. But maybe that's what you meant.

A minor point. If it's just a single step, don't use a script, as Fitch says. But we aware that the single step will "open" the record and leave it open. Whereas a 2-step script, with Commit Record as the 2nd step, would not.

Of course, a user editing the field would also open the record, and it's difficult to think of a situation where it would be a problem. But it's something to be aware of. I'd also almost always just use the single step, as I don't like cluttering the scripts.

Select the item again with the Shift key pressed.