SetValue to prevent data entry?

R

Randy

Can I use SetValue to prevent data entry of a case number field after
it has been entered once?

The field is called Number.

How would I code?
 
S

Steve Schapel

Randy,

Do you mean make the textbox unable to be edited if it has a number in
there? If so, then yes, you could handle this with a SetValue macro.

Action: SetValue
Item: [Number].[Locked]
Expression: Yes

You might also want to do this as well...
Action: SetValue
Item: [Number].[Enabled]
Expression: No
 
S

Steve Schapel

Randy,

Apologies, I forgot the most important bit! In your macro you will need
a Condition...
[Number] Is Not Null

And then you will proabably also need another action in the macro to
handle the other condition:

Condition: [Number] Is Null
Action: SetValue
Item: [Number].[Locked]
Expression: No
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top