List Box Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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>
 
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
 
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>
 
Nope.

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

LDN

:
 
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>
 
Back
Top