List Box Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

roccogrand - 29 Nov 2005 17:05 GMT

I have a List Box on one of my forms that fails to show certain records when
an index record is clicked. It works fine for other records. The data are in
the table for all of the records but this is an application that I have
reused a few times by deleting records from tables.

The table contains several memo fields, an URL hyperlink field, and a
hyperlinked image field.

Q: Is there a way to clean the table so that the List Box retrieves every
record's data? What would cause this to happen, other than forty deleted
records?

Thanks.

Reply to this Message

Jeff Boyce - 30 Nov 2005 00:52 GMT

No idea what you mean when you say "an index record"...

A list box gets "filled" by an underlying SQL statement/query. Please post
the SQL statement your list box is using.

Regards

Jeff Boyce
<Office/Access MVP>

>I have a List Box on one of my forms that fails to show certain records
>when
[quoted text clipped - 11 lines]
>
> Thanks.

Reply to this Message

roccogrand - 30 Nov 2005 02:12 GMT

Sorry for being so cryptic Jeff. I use List Box in a pretty basic manner to
select a record using a particular field that I refer to as the Index. The
SQL is simply:

SELECT qryBoilerplate.Service FROM qryBoilerplate;

My List Boxes are created via the wizard using option 3. Only one field is
used.

LDN

> No idea what you mean when you say "an index record"...
>
[quoted text clipped - 21 lines]
> >
> > Thanks.

Reply to this Message

Jeff Boyce - 30 Nov 2005 19:16 GMT

If "qryBoilerplate" is the source of your list, then perhaps the query is
not selecting all the records you expect to see...

Regards

Jeff Boyce
<Office/Access MVP>

> Sorry for being so cryptic Jeff. I use List Box in a pretty basic manner
> to
[quoted text clipped - 39 lines]
>> >
>> > Thanks.

Reply to this Message

roccogrand - 30 Nov 2005 20:36 GMT

Nope.

All of the data are there. I copied one of the fields into Word and
everything appears in RTF.

LDN

> If "qryBoilerplate" is the source of your list, then perhaps the query is
> not selecting all the records you expect to see...
[quoted text clipped - 47 lines]
> >> >
> >> > Thanks.

Reply to this Message

Jeff Boyce - 30 Nov 2005 22:25 GMT

Please post the SQL of your query.

(and worst case, consider dumping the query that doesn't work and re-writing
it.)

Jeff Boyce
<Office/Access MVP>

> Nope.
>
[quoted text clipped - 60 lines]
>> >> >
>> >> > Thanks.

Reply to this Message