Re: Rowsource combo box reseting

From: Sandra Daigle (Invalid_at_KeepYourSpam.org)
Date: 03/10/05 

Date: Thu, 10 Mar 2005 13:36:05 -0500

Call the same code in the Current Event of the form - this event fires after
record navigation so it's the place to do requeries and this type of thing.
FWIW, if the code is more than one or two lines I would probably put it in a
separate procedure and call that procedure from both the AfterUpdate event
and from the Current event rather than duplicating the entire set of code in
two places (which leads to maintenance nightmares). 

-- 
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.
EllandRD wrote:
> have 4 combo boxes whos row source is dependant on the first 2.EG
>
> CBOA   drives the rowsource for CBO B and CBOD
>
> CBO B drive the Row source for CBOC
>
> CBOA is on the main form   CBO B<C<D or on a subform
>
> The row source is set on After update events on the CBO Boxes
>
> All data returened is fine.
>
> BUT
>
> When i look up old information the rowsource seems to be stuck on the
> last entry i loooked at. So data looks like it is missing in bits and
> parts part of my contious form.
>
> Helppp

Relevant Pages

  • Rowsource combo box reseting
    ... CBOA drives the rowsource for CBO B and CBOD ... CBO B drive the Row source for CBOC ...
    (microsoft.public.access.formscoding)
  • Re: Form Advice Relating to Queries
    ... I will have a look at the cbo as a record selector on your site next, ... Test that the query works. ... Row Source Property Entered By Query Wizard ...
    (microsoft.public.access.forms)
  • Re: Rowsource combo box reseting
    ... Recordsource query of the form (join the foreign table and drag in the ... > Peter <--- Selected CBOA ... >> CBOA drives the rowsource for CBO B and CBOD ... >> CBO B drive the Row source for CBOC ...
    (microsoft.public.access.formscoding)
  • Re: populating a second combo box depending on the first combo box
    ... Create a query named QryTypeGen based on your table and only include the ... For the first Cbo, make this query the ... rowsource. ... Create a second query named QryTypeSpe based on your ...
    (microsoft.public.access.gettingstarted)
  • Re: How do I resort a cbo on a form?
    ... The RowSource for the cbo called cboEssayID is: ... Private Sub txtEssayRankID_AfterUpdate ... >>When I make a change the affects the sort order of the current record on ...
    (microsoft.public.access.gettingstarted)