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