Enter the name and get automatically the personal ID number

  • Thread starter Thread starter Oliver
  • Start date Start date
O

Oliver

The table 1 "Reference name" contain:
1. Name
2. Personal ID number.

The table 2 "Task"contain:
1. Name
2. Personal ID number
3. Task
4. StartDate
5. FinishDate
Into a form ( based on table 2), when a person is entering the Name I would
like that the Personal ID number is automatically entered ( based on the
information entered into table 1).
Thanks for your help.
Oliver
 
Use a combo box to view the Name, but store the ID value. There is a wizard
to help you do that, just make sure that in design view, you have the
wizards turned on in the toolbox.
 
Dear Arvin,
Thanks for your answer, but my need is a little different.
I need an another function Like enter the name of a person into combo box 1
(cb_Name)
and get automatically the Personal number into combo box 2 (cb_IDNumber).
Regards.
Olivier
 
You should use a textbox if you need to display the ID number. Make that
textbox unbound and set its controlsource property to:

=Forms!YourFormName!cb_Name.Column(0)

If you've use the wizard, you should have a 2 column combo box with the
first column (column(0)) being IDNumber, and the second Name.

I do not understand why you need to display the IDNumber which should be
meaningless. You should also not use the fieldname "Name" as it is a
reserved word.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Back
Top