ajking
Technical User
- Aug 13, 2002
- 229
I have an unbound listbox which gets its value from a query.
When I run it, the listbox is blank. when I go to the properties of the listbox, the rowsource is missing.
when I select the query from the dropdown box, the missing values appear in the listbox.
As soon as I go to the next record I get the same problem; the rowsource is blank again
Opening the query itself shows that it has the data I expect to be there.
I have tried recreating the listbox but I still get the same result.
I am down to the last few hairs on my head! Can anyone help please. TIA
'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980
When I run it, the listbox is blank. when I go to the properties of the listbox, the rowsource is missing.
when I select the query from the dropdown box, the missing values appear in the listbox.
As soon as I go to the next record I get the same problem; the rowsource is blank again
Opening the query itself shows that it has the data I expect to be there.
I have tried recreating the listbox but I still get the same result.
I am down to the last few hairs on my head! Can anyone help please. TIA
'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980