[AccessD] Design question

Using Susan's suggestion, I'd make it a tad bit different.
When creating the combo box, for the Row Source use a SQL statement using a group-by to refer back to the same field that's being updated.  The user can still type in anything that is needed.  Do a requery on the On Enter event. This way all titles used are available and new ones can be added. 
 
Jim H.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Friday, December 10, 2004 9:39 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Design question


 
I can't get excited over tables of titles.  What's the point in having one?
Little if any savings or gains in space, performance, complexity,
ergonomics, etc - in fact the opposite, mostly.  Just let them type it in!
And store it in the record with the name(s).

=========I think I agree, but you could make it a tad easier by offering a
combo with the choices -- make the default the most often used title and be
done with it. 

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com