Bound Control

  • Thread starter Thread starter Kou Vang
  • Start date Start date
K

Kou Vang

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

Me.BoundContrl.value = x

Thanks,

Kou
 
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?
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Get values for function 4
Reflect Control Source Change via VBA 4
Event order for Calculated Control 1
Runtime error 2448 1
Trying Ken's API file dialog for first time 10
Delete Table in Another Database 4
VBA refer to lookup value (not bound value) 2
Write to a table 3

Back
Top