I created a Contact Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a Contact Database. Fields are : Employee Name, Department,
Designation,Mobile#, Email Address. Once I just input Depatment field I am
facing a problem as follows :
for example I have to input "Marketing Strategies" Department. Sometimes
mistakenly I will put "Marketing" only without Strategies. To avoid this
problem I think I can enter the Department field through Combo Box. But
sometimes unnecessarily clicked that field in Combo Box then I put any other
department, then once I have not changed field it will stay as it is in
mistake. To avoid this is there any other idea from your end ? I think you
got my idea. As long as we are not locking the Combo Box field after we
enter data, sometimes there will be chance to change by user. Please suggest
the solution for this problem.
 
Mistakes are mistakes if you make them during input they STAY for the most
part.

If I were you I would make a table Valid Departments and places all the
options in there. Restrict it to the LIST in the property pilot and at least
this way you can only have VALID ENTRIES. Make the combo box open upon entry
and it will automatically go to the department entry as your typing. If it
is the only one that is close it will automatically fill in the FIELD with
minimum keystrokes.

This should cure your problem of the mistakes during entry. If your doing
entry when you only want to Read and Review the Record set the record to READ
only accept when your doing a input process.


Diwght
 
Great! I got your point. Now I need to know how to create this Combo Box for
Department field in my Contact Form. Please inform.
-------------------------------------------------------------------------------
 
Basically

Use the wizard

First build a ValidDepartmentTable with Field DEPARTMENT

Open the table and put in your valid department names, numbers or whatever

Go to your form. Use the Combo box wizard and place the box on your form.

When the wizard ask do you want the combo box to look up the data or do you
want to type it in select : I want the combo box to look it up. Select the
ValidDepartmentTable at that point and the Dept Field will store your
selection.

Once the Dept COMBO box is on the form and working ok. Open in design view
and set the property pilot to Limit to List to YES. This will ensure that
only what is in the list can be selected and input so it would always be
right.

When making selections open the box first either by clicking on the down
arrow to the right of the combo box or make it open using code. It is best
to open it with code and this can be found in the help files.

Try this and hopefully it will work well for you. GOOD LUCK!

Dwight
 
Hans,
Great! Now Combo Box is working in the way I want. I am very happy
--------------------------------------------------------------------------------
 
Back
Top