Home Version Access
On Sun, 26 Nov 2006 09:31:02 -0800, accessdesigner
wrote:
ty... ( need you all on speed dial.... lol)
my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox
The Query: NameThings .....is only connected to my Report
The word Name is a bad Name to Name a field or a control, since both
tables and controls have a Name property already!
Try changing the table definition so that you're using a nonreserved
term in place of Name - or at the very least bracket it.
The difference between the home and work versions *MIGHT* be because
one of them has Name Autocorrect set in the database's Options, and
the other doesn't. IN my experience this misfeature should be turned
OFF.
Perhaps you could post the complete SQL of the NameThings query, with
some indication of the datatypes of the table fields.
John W. Vinson[MVP]
|