Re: [MS_AccessPros] Combo Box

 

Duane,

I tried with SQL statement like you did. It does not make a difference. If I type 'D' , it does not fill in Delaware, it shows Delaware in the drop down. I have to type out Delaware or select it from the Drop Down. But if I type 'D', I would like it to automatically fill in Delaware, the first selection that starts with D. 

Sarah

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

I tested with A 2016 and the find as you type with a table worked as expected. I don't recall ever using either a table or query name as a row source. I always use an SQL statement like:

Select StateAbbrev, StateName from tblStates Order By StateName. 

Duane

Sent from Outlook

On Mon, Nov 2, 2015 at 2:50 PM -0800, "sarahk@... [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

I have a combo boxes on a form. The row source is a table. For example I have a state table that is the row source. The combo box works, but if I start typing a value I would like it to automatically bring up the appropiate items from the state table. For example if I type 'new' then all the states that start with 'new' should come up. This does not work if the row source is a table, but it does work if the row source is a query. If I crate a query based on my state table and use it as the row source, it works fine. If the row source is a table, then it should shows the enries from the very begining starting with 'A".

Is this by design?. Or do I need to change my settings?. The table is linked to a back end. I would like the row source to be the table, so I dont have to create 'extra' queries.

I am using Access 2003.

As always all help is appreciated.

Sarah

__._,_.___

---

Posted by: sarahk@schemesoftware.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (27)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___