[AccessD] State/County table part 2

frmDataEntry

-- 
Stuart

On 1 Jan 2013 at 19:36, Kathryn Bassett wrote:

> In which table, query or form? For some reason,  I can't find the place to
> change it in any of those.
> 
> Forgot about compacting.
> 
> Kathryn
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> > bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> > Sent: 01 Jan 2013 7:23 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] State/County table part 2
> > 
> > That's better.  :-)
> > 
> > And incidentally, I just Compacted it and the 55Mb went down to 720KB.
> > 
> > Change the record source of MarrCounty to:
> > 
> > SELECT tblCounty.County, tblCounty.ID, tblCounty.tblState_ID FROM
> tblCounty
> > WHERE
> > (((tblCounty.tblState_ID)=[Forms]![frmDataEntry]![MarrState])) ORDER BY
> > tblCounty.[County];
> > 
> > Add the following event procedure to MarrState:
> > 
> > Private Sub MarrState_AfterUpdate()
> > MarrCounty = ""
> > MarrCounty.Requery
> > End Sub
> > 
> > 
> > That will do it.
> > 
> > --
> > Stuart
> > 
> > 
> > 
> > On 1 Jan 2013 at 17:17, Kathryn Bassett wrote:
> > 
> > > > I would have downloaded it and answered your questions if you had
> zipped
> > > it,
> > > > but a 55MB download will just cost me too much time and money :-(
> > >
> > > Sorry about that :)
> > > https://www.dropbox.com/s/go98nfxsc15e2wl/MarriageIndex.zip
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > 
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>