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