ghost entries in fields

  • Thread starter Thread starter papa jonah
  • Start date Start date
P

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
 
Perhaps someone used <shift-enter> in a field instead of just <enter>. Is
there a little box between the duplicate text in the cell?
 
I use a series of dropdowns in a form. The dropdowns are populated
from zlookup tables.
Click to expand...

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?
Click to expand...

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]
 
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.
 
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.
Click to expand...

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]
 
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!
 
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.
 
Back
Top