List box and dissapearing data

[John Finch]

Hi There,

I have a form with some text boxes to enter search criterior and a
list box to display the results. Depending on which text boxes are
filled in the row source is given the correct query name via code.

If the list box displays 20 results - 5 fit in the box and the other
15 are found by scrolling - and all works fine. My problem lies in
that as soon as you select one of the records in the list box which
then displays full details of that entry on a sub form below the list
box starts misbehaving. If you now scroll down to view the other 15
results that were there before thay are now gone and only the 5
results that were shown in the box are left - where have all the other
results gone?

If anyone can tell me if this is a bug in access I would be greatful
and I shall have to think about using a subform to display the search
results - I would prefer to stick with the list box if possible as a
lot of other stuff within the database is already set up to work from
what ever is selected in it.

thanks for any help you can offer.

with best wishes

John Finch

[John Finch]

I found the answer and as I could not find any other answer to this
question that has been asked a few times on this group (short of
sending a repeated F9 keystroke to the list box on a loop - which
didn't really seem the ideal answer!) thought it best to write the
answer down for anyone to see.

There seems to be a bug in MS Access that if you set the row source
using code for a list box and there are less columns in the query
result than are expected by the list box you start getting strange
behaviour.

In my case my list box was expecting 9 columns but the query I was
setting only had 8 fields at which point all my strange disapearances
started.

thanks for reading

Regards

John

jf****@abrsm.ac.uk (John Finch) wrote in message news:<4d**************************@posting.google. com>...

Hi There,

I have a form with some text boxes to enter search criterior and a
list box to display the results. Depending on which text boxes are
filled in the row source is given the correct query name via code.

If the list box displays 20 results - 5 fit in the box and the other
15 are found by scrolling - and all works fine. My problem lies in
that as soon as you select one of the records in the list box which
then displays full details of that entry on a sub form below the list
box starts misbehaving. If you now scroll down to view the other 15
results that were there before thay are now gone and only the 5
results that were shown in the box are left - where have all the other
results gone?

If anyone can tell me if this is a bug in access I would be greatful
and I shall have to think about using a subform to display the search
results - I would prefer to stick with the list box if possible as a
lot of other stuff within the database is already set up to work from
what ever is selected in it.

thanks for any help you can offer.

with best wishes

John Finch