Enter the name and get automatically the personal ID number

[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

 

[Arvin Meyer [MVP]]

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.

 

[Oliver]

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

 

[Arvin Meyer [MVP]]

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

 

[Oliver]

Dear Arvin,
Thanks a lot it works.
Best Regards.
Oliver