K Kou Vang Jul 24, 2008 #1 Can you not assign a value to a Bound Control via VBA? ie: Me.BoundContrl.value = x Thanks, Kou
K Klatuu Jul 24, 2008 #2 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?
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?
M Marshall Barton Jul 24, 2008 #3 Kou said: Can you not assign a value to a Bound Control via VBA? ie: Me.BoundContrl.value = x Click to expand... 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.
Kou said: Can you not assign a value to a Bound Control via VBA? ie: Me.BoundContrl.value = x Click to expand... 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.