[AccessD] State/County table part 2

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