By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,708 Members | 1,456 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,708 IT Pros & Developers. It's quick & easy.

Synchronizing duel combo boxes

P: n/a
Hi

This is a repost due to no responses

Here's a problem I've encountered with Access 2003 which has got me to
redesign how I get the row source in a second combo box using the first
combo box as a filter.

In Access 2002 and earlier the row source for the second combo was "SELECT
Field1, Field2 etc, FROM MyTable WHERE Field3 =
[Forms]![frmMyForm]![cboFirstCombo]" and in the AfterUpdate event of the
first combo box was Me!cboSecondCombo.Requery.

Whenever my clients upgraded to Access 2003, the synchronizing of the duel
combo boxes didn't work which resulted in writing code to fill the row
source of the second combo after a selection was made in the first combo.
Has any one else encountered this problem and what was your solution. Have
done a quick search on Microsoft's web site but no luck there.

Thinking it might have been a problem with the upgrade I created a test
database from scratch using Access 2003 and had the same problem, I had to
use code to fill the second combo box and couldn't use the row source in the
combo's property sheet.

Jeff
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 10 Jan 2005 08:45:16 +1300, "Jeff Smith"
<No****@Not.This.Address> wrote:
Hi

This is a repost due to no responses

Here's a problem I've encountered with Access 2003 which has got me to
redesign how I get the row source in a second combo box using the first
combo box as a filter.

In Access 2002 and earlier the row source for the second combo was "SELECT
Field1, Field2 etc, FROM MyTable WHERE Field3 =
[Forms]![frmMyForm]![cboFirstCombo]" and in the AfterUpdate event of the
first combo box was Me!cboSecondCombo.Requery.

Whenever my clients upgraded to Access 2003, the synchronizing of the duel
combo boxes didn't work which resulted in writing code to fill the row
source of the second combo after a selection was made in the first combo.
Has any one else encountered this problem and what was your solution. Have
done a quick search on Microsoft's web site but no luck there.

Thinking it might have been a problem with the upgrade I created a test
database from scratch using Access 2003 and had the same problem, I had to
use code to fill the second combo box and couldn't use the row source in the
combo's property sheet.

Jeff

Hi
Are you saying that the method described in the kb article below
doesn't work?
David

How to synchronize two combo boxes on a form in Access 2002 or in
Access 2003
http://support.microsoft.com/default...b;en-us;289670
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.