Execute Method question...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NWO - 17 Dec 2005 21:24 GMT

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 :)

Reply to this Message

Ofer - 17 Dec 2005 21:41 GMT

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

Signature

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

> Hello Access Programming Community.
>
[quoted text clipped - 12 lines]
>
> NWO :)

Reply to this Message

NWO - 17 Dec 2005 21:57 GMT

Thanks Ofer, you answered the question.

Happy Holidays!

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

> You can do that by refreshing the list box or combo after executing the query
> (SQL), using
[quoted text clipped - 20 lines]
> >
> > NWO :)

Reply to this Message