ghost entries in fields

[papa jonah]

I use a series of dropdowns in a form. The dropdowns are populated
from zlookup tables.
On occassion, an entry is duplicated in a field. What I mean is after
downloading query info to excel, occassionaly I see a cell that has the
same data listed twice within a cell.

What would cause this, and how can I stop it?

TIA

 

[Mark M]

Perhaps someone used <shift-enter> in a field instead of just <enter>. Is
there a little box between the duplicate text in the cell?

 

[John Vinson]

I use a series of dropdowns in a form. The dropdowns are populated
from zlookup tables.

Do you mean "zlookup"? If so, what's a zlookup? It's certainly not an
Access feature.

What is the Recordsource for this form? What are the Control Sources
of the combo boxes (i.e. where are they storing data)?

On occassion, an entry is duplicated in a field. What I mean is after
downloading query info to excel, occassionaly I see a cell that has the
same data listed twice within a cell.

What would cause this, and how can I stop it?

The only thing that I can think of would be some (badly written) VBA
code changing the way combo boxes work.

John W. Vinson[MVP]

 

[papa jonah]

zlookup being nothing more than a table. naming them as zlookup ...
keeps them all together in the listing of tables.
nohing fancy.

They are the reference sources for the dropdowns.
There is no vba coding - only what access may create when you fill in
the properties of tables or queries.

 

[John Vinson]

zlookup being nothing more than a table. naming them as zlookup ...
keeps them all together in the listing of tables.
nohing fancy.

They are the reference sources for the dropdowns.
There is no vba coding - only what access may create when you fill in
the properties of tables or queries.

Then please post the Recordsource sql for the Form, and the Control
Source and RowSource properties of the combos. I don't see how a combo
box *can* do this!


John W. Vinson[MVP]

 

[papa jonah]

Form's Record Source:
Subtype

Control Source:
Subtype

Rowsource from the form:
SELECT DISTINCTROW [Zlookup: Subtype].Subtype FROM [Zlookup:
Subtype];

Is this all you need? I have always made Access out to be more
complicated!

 

[Douglas J. Steele]

Try:

SELECT DISTINCT [Zlookup: Subtype].Subtype FROM [Zlookup: Subtype];

instead.

DISTINCTROW looks at all fields in the row, whether or not they're being
selected. DISTINCT only looks at the selected fields.