[AccessD] Design question

Thanks for your replies - I'll keep the table but simply present this
for use in a drop down combo and store the result in a text field. I
appreciate the lookup of actual values entered - varying typing skills
could result in mistyped/spelled entries which then presents the user
with a duff list and the task of finding the duff entries - thanks.
R

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

Good idea. :) 

Susan H. 

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. 
 

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