Execute Method question...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Access Programming Community.

NWO here sending this Q on behalf of a colleague...

When a database table is updated using the VBA connection object “execute
method†the related tables are updated immediately but objects such list,
combo box, etc. does not reflect the changes until I re-load the form that
contains the objects. Sometimes the list box would display #delete in the
record if a delete command is executed.

How can I get the all objects on a form to reflect changes to the related
tables immediately after updating the table?

Thank you.

NWO :)
 
You can do that by refreshing the list box or combo after executing the query
(SQL), using

Me.ListName.Requery

Or
Forms![FormName]![ListName].Requery
 
Thanks Ofer, you answered the question.

Happy Holidays!

NWO :)
------------------

Ofer said:
You can do that by refreshing the list box or combo after executing the query
(SQL), using

Me.ListName.Requery

Or
Forms![FormName]![ListName].Requery

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



NWO said:
Hello Access Programming Community.

NWO here sending this Q on behalf of a colleague...

When a database table is updated using the VBA connection object “execute
method†the related tables are updated immediately but objects such list,
combo box, etc. does not reflect the changes until I re-load the form that
contains the objects. Sometimes the list box would display #delete in the
record if a delete command is executed.

How can I get the all objects on a form to reflect changes to the related
tables immediately after updating the table?

Thank you.

NWO :)
Click to expand...
Click to expand...
 
Back
Top