Editable field

[Kundan]

I have field on a form to which I have assigned a function which returns a string. But sometimes I need to edit the string returned by the function. This is not possible in the field which is bound to the function. Is there a way in which I can edit the field as well as have it bound to the function?

[June7]

Use VBA to run function and set value of field. Trick is figuring out what event to call function.

[Missinglinq]

You can't assign the ControlSource of the Control to your Function, in the Properties Pane, i.e.

= FunctionName

You'll have to use some other event and code such as,

Me.ControlName = FunctionName

Then you will be able to edit the value.

Linq ;0)>

[Gicu]

Or maybe use the default value property to add the value returned by the function when creating a new record.

Cheers,
Vlad

[Missinglinq]

...Or maybe use the default value property to add the value returned by the function when creating a new record...

That would depend, I think, on whether or not the Function depends on some value that first has to be entered in the New Record.

Linq ;0)>

[Kundan]

Use VBA to run function and set value of field. Trick is figuring out what event to call function.

Thanks!! GOD BLESS YOU!!!!!

[Kundan]

You can't assign the ControlSource of the Control to your Function, in the Properties Pane, i.e.

= FunctionName

You'll have to use some other event and code such as,

Thanks!! GOD BLESS YOU!!!!!

Me.ControlName = FunctionName

Then you will be able to edit the value.

Linq ;0)>

Thanks!! GOD BLESS YOU!!!!!

[Missinglinq]

Glad we could help!

Linq ;0)>