[AccessD] Related combos in a datasheet

Hi Arthur,
I *think* I have a solution, but I have to go out now.  Will post it when I
check it later.
Regards
Max
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, September 04, 2007 11:19 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Related combos in a datasheet

Interesting. i will try that on a little test program.

A.

On 9/4/07, Steve Schapel <miscellany at mvps.org> wrote:
>
> Arthur,
>
> I am not sure about datasheet, I don't have any experience with that.
> But in a contunuous form you can do code like this, on the Enter event 
> of the second combobox:
>    Me.SecondCombo.RowSource = "SELECT whatever FROM YourQuery WHERE 
> YourField = " & Me.FirstCombo ... and then on its Exit event:
>    Me.SecondCombo.RowSource = "SELECT whatever FROM YourQuery"
>
> This will not work if you use the traditional Requery of the second 
> combobox on the After Update of the first.
>
> Regards
> Steve
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com