On Mon, 10 Jan 2005 08:45:16 +1300, "Jeff Smith"
<NoSpam@Not.This.Address> wrote:
[color=blue]
>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
>
>[/color]
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 
