[AccessD] State/County table part 2

Oops, I forgot, you alos need:

Private Sub Form_Current()
MarrCounty.Requery
End Sub



On 2 Jan 2013 at 13:23, Stuart McLachlan wrote:

> 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
>