Bound Control

[Kou Vang]

Can you not assign a value to a Bound Control via VBA? ie:

Me.BoundContrl.value = x

Thanks,

Kou

[Marshall Barton]

Kou Vang wrote:

>Can you not assign a value to a Bound Control via VBA? ie:
>
>Me.BoundContrl.value = x

You can:
If the bound control/table/field's validation rules permit
the new value.

If the form's record source query is updatable.

If you are using record locking or pesimistic locking and
there is no conflict with another user.

--
Marsh
MVP [MS Access]

[Klatuu]

Yes, you can, provided it is bound to a field in the form's record source.
If it an expression, then you can't.
What are you trying to do that is not working?
What error are you getting?

--
Dave Hargis, Microsoft Access MVP