Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 12th, 2006, 01:21 PM
Registered User
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access combo box does not work with SQL Server


I am migrating an Access Application to an SQL Server. One of the issues I have run into is that my combo boxes do not work correctly.

The combo box is unbound and uses a query to populate it's contents. The query (called ddQry) is of the form:

SELECT ID, NAME from tblCode where codetype='flavor'

The relavent properties on the combo are:
RowSourceType: Table/Query
Row Source: ddQry
ColumnCount: 2
Column Widths: 0";2"

The results of the query are of the form:

1, Orange
2, Mint
3, Lemon

What happens is when tblCode is an Access table, the combo box works as expected. However, when I migrate the table to SQL server, all items show up when you drop down the list, but after you select one the combo is empty. Also, if you change the column widths to display the first column the values do show after selection, but as expected just the number is displayed.

Any thoughts?



Old July 12th, 2006, 02:31 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Is this a linked table or a data connection/recordset? Is this a local query you are looking up, or a SQL view?

Still ruminating...

Old July 14th, 2006, 03:00 PM
Registered User
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

The table referenced in the query is linked to the SQL database.

Also, I make this happen in trivial form that just has a combo box and a query to a linked table.

Any insight is greatly appreciated.


Old July 14th, 2006, 03:30 PM
Registered User
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

Also, the query runs against the linked table, not against a view.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Data from a combo box darkhalf Access VBA 1 February 22nd, 2008 04:28 PM
combo box doesnt work in IE7 but Firefox mamuco Classic ASP Components 1 June 4th, 2007 10:10 AM
Combo box dropped down don't work proper Sneha Patel Book: Wrox's Visual C# 2005 Express Edition Starter Kit 1 May 28th, 2007 07:08 AM
Combo box can not work with dynamic Range dahlia492 Excel VBA 1 November 20th, 2006 12:43 PM
Access Combo box with sql server jbritz Access 4 June 18th, 2003 11:33 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.