Hello,
I am looking for some help with the following problem. I have a listbox on a form that populates via the following code:
strSQL = "SELECT [Ticket Number], [User Name], [Phone Number DSN], [Computer Name], [Building Number], [Room Number], [Date Problem Started], [Type of Issue], [Status] FROM Helpdesk"
Me.lstTickets.RowSource = strSQL
Me.lstTickets.Requery
This works great however If someone were to add a new entry into the Helpdesk table, the data would not appear on this listbox without another requery. At the moment to mitigate this I am using a "refresh" button that executes the code:
Me.lstTickets.Requery
I would like to know if it is possible to automatically update the listbox whenever changes are made to the helpdesk table, without locking up the form.
Thanks!
I am looking for some help with the following problem. I have a listbox on a form that populates via the following code:
strSQL = "SELECT [Ticket Number], [User Name], [Phone Number DSN], [Computer Name], [Building Number], [Room Number], [Date Problem Started], [Type of Issue], [Status] FROM Helpdesk"
Me.lstTickets.RowSource = strSQL
Me.lstTickets.Requery
This works great however If someone were to add a new entry into the Helpdesk table, the data would not appear on this listbox without another requery. At the moment to mitigate this I am using a "refresh" button that executes the code:
Me.lstTickets.Requery
I would like to know if it is possible to automatically update the listbox whenever changes are made to the helpdesk table, without locking up the form.
Thanks!