PDA

View Full Version : Best method to select Unit Number



RonNCmale
03-16-2011, 10:46 PM
I have a 2003 database that has a text box that the user will input a 4 digit number that corresponds with the Units Name. Example Wilkes County = 3124, there are approximately 100 different units so there are 100 different numbers. Also they are separated by regions. Example Eastern, Central, etc. I'm trying to make it easier for the user to input the different numbers. I thought about a dialog box, or would a combo box work? Is the combo box limited to the number that can be stored. Any ideas

OBP
03-17-2011, 03:19 AM
Ron, I would always use a combo box, it can display the County, Region and the number, that way the users can be sure that they have the right number. But the big advantage is the prevention of typographical errors and ending up with numerous incorrect values.

RonNCmale
03-17-2011, 08:51 AM
Thanks for your input OBP, I'm going to give this a shot. Thanks again.