[AccessD] Re: Combo on Continuous Form

Mark:

I'd use the on current event to structure an SQL statement based on the
appropriate values in the current record.  The set the combo rowsource and
requery the combo box.

I'm assuming that if the user clicks the combo box of a record which is not
the current record the OnCurrent event triggers first so the combo box row
source will be reset and requeried before it drops down.

Otherwise you may have to put the code into the OnClick event of the combo
box, or even the GotFocus event on the theory that the user could tab into
the box.

But I would try the OnCurrent first.

Rocky

----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, March 10, 2004 1:51 PM
Subject: RE: [AccessD] Re: Combo on Continuous Form


> Robert,
>
> My original post was:
>
> In A2k I want a combo box on a each row of the continuous form that
filters
> by the current record on that continuous form.  Suggestions anyone?
>
> Thanks,
>
> Mark
>
>
> >From: "Robert L. Stewart" <rl_stewart at highstream.net>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: accessd at databaseadvisors.com
> >CC: markamatte at hotmail.com
> >Subject: [AccessD] Re: Combo on Continuous Form
> >Date: Wed, 10 Mar 2004 10:15:22 -0600
> >
> >Mark,
> >
> >What are you trying to accomplish?
> >
> >For example:
> >
> >I want a combobox on each row of a subform so I
> >can use it to open a second form with information
> >filtered not only by the information in the subform,
> >but also limited by my selection in the combobox.
> >
> >Please give use more information.
> >
> >Thanks
> >
> >Robert
> >
> >At 08:34 AM 3/10/2004 -0600, you wrote:
> >>Date: Wed, 10 Mar 2004 04:42:13 +0000
> >>From: "Mark A Matte" <markamatte at hotmail.com>
> >>Subject: RE: [AccessD] Combo on Continuous Form
> >>To: accessd at databaseadvisors.com
> >>Message-ID: <BAY1-F111NVYlLdHMuk0000eea9 at hotmail.com>
> >>Content-Type: text/plain; format=flowed
> >>
> >>Jürgen,
> >>
> >>If by multiple instances...you mean same combo appearing on each
> >>row/record...then yes...this is what I am trying to accomplish.
> >>
> >>Thanks,
> >>
> >>Mark
> >
> >
> >--
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar - get it now!
> http://clk.atdmt.com/AVE/go/onm00200415ave/direct/01/
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>