Unbound form

[IanT]

I have a unbound form with a list box and text box's. I select a item from the list box and input data in the text box's then run some code to update a table using the selected items. I us a combo box on the form to filter down the items in the list box. The problem, when I run through the process the first time all works OK, after which the combo filter, after selecting a item the list box will not update just shows blank, it appears that the form needs to be reset or something, has anyone any ideas!

Thanks in advance!

 

[maxmangion]

try requerying your listbox Me.ListboxName.Requery

 

[kidrobot]

Hey I'm having the same problem. This code works to reset the box and it appears blank but for some reason behind the scenes it is retaining the code (code of my recordset) causing me to have an error. How can I make the listbox value back to NULL? I tried setting it equal to Null but it didn't work.

 

[kidrobot]

never mind I got it to work by adding

lstReports = Null
then doing the Me.lstreports.requery

Didn't think adding that lstreports=null would make a difference.