Why is this happening...

[Bob]

I have a dropdown list Combobox that has products I can select or at a new
one to the list, but if I have say Sandpaper on my list and I want to enter
Sandbox I can get past the word sand to enter the rest "box". I have been
starting with a dot then type Sandbox then delete the dot out, surely there
must be a better way...thanks bob







..........Jenny Vance

 

[John Vinson]

I have a dropdown list Combobox that has products I can select or at a new
one to the list, but if I have say Sandpaper on my list and I want to enter
Sandbox I can get past the word sand to enter the rest "box". I have been
starting with a dot then type Sandbox then delete the dot out, surely there
must be a better way...thanks bob

This makes no sense! A combo box will automatically SUGGEST a
completion. Are you trying to enter a *new* product which is not in
the table already? If so, what are the Limit to List and On Not In
List properties of the combo?

John W. Vinson[MVP]

 

[Bob]

This makes no sense! A combo box will automatically SUGGEST a
completion. Are you trying to enter a *new* product which is not in
the table already? If so, what are the Limit to List and On Not In
List properties of the combo?

John W. Vinson[MVP]

Thanks John,
Limit to List [No]
On Not In List [Blank]
Thanx for your Help.............Bob

 

[John Vinson]

Thanks John,
Limit to List [No]
On Not In List [Blank]
Thanx for your Help.............Bob

And it's autofilling!?

Something is VERY screwy. Please explain the context; do you WANT to
limit to list? do you want to autocomplete if the value does exist?
What's the RowSource (post the SQL)? What's the Bound Column and
Column Count?

John W. Vinson[MVP]

 

[Bob]

Thanks John,
Limit to List [No]
On Not In List [Blank]
Thanx for your Help.............Bob

And it's autofilling!?

Something is VERY screwy. Please explain the context; do you WANT to
limit to list? do you want to autocomplete if the value does exist?
What's the RowSource (post the SQL)? What's the Bound Column and
Column Count?

John W. Vinson[MVP]

I would like it to auto complete if the name is already in the list
I don't want to limit the list, I Think!
Column Count 1
Bound Count 1
SQL;
SELECT DISTINCT tblHorseInfo.FatherName
FROM tblHorseInfo
WHERE (((tblHorseInfo.FatherName) Is Not Null));
Thanks Bob

 

[Bob]

Thanks John, Turned off Auto Correct............Bob

Thanks John,
Limit to List [No]
On Not In List [Blank]
Thanx for your Help.............Bob

And it's autofilling!?

Something is VERY screwy. Please explain the context; do you WANT to
limit to list? do you want to autocomplete if the value does exist?
What's the RowSource (post the SQL)? What's the Bound Column and
Column Count?

John W. Vinson[MVP]

I would like it to auto complete if the name is already in the list
I don't want to limit the list, I Think!
Column Count 1
Bound Count 1
SQL;
SELECT DISTINCT tblHorseInfo.FatherName
FROM tblHorseInfo
WHERE (((tblHorseInfo.FatherName) Is Not Null));
Thanks Bob