[AccessD] Friend needs Access help

Stuart McLachlan stuart at lexacorp.com.pg
Mon Mar 3 16:46:11 CST 2014


I've taken a look at Jim's problem and here's the crux of my response to him:

Jim already had a field called AutoNum in his Membership  table. so I: 
1. Made that the Primary key 
2. Included it in the row source SQL of the unbound "Find" combobox. 
3. Made it the "Bound Column" of the combobox 
4. Used it as the criteria for the FindFirst in  the combobox After_Update event

-- 
Stuart
 

On 3 Mar 2014 at 9:15, Kathryn Bassett wrote:

> Jim, welcome to the list! Since you are having a dialog off list, be
> sure to do a recap when the problem is solved so the archives have the
> answer.
> 
> This is a great group, even to the personal touch as you'll see in my
> Converting Case thread.
> 
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net   
> 
> 
> 
> 
> > -----Original Message-----
> >  Thanks.  I have replied off list to Stuart.
> > 
> > Jim Barrett - Timpson, TX
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list