Autocopy from a field

[New2Tek]

I'm creating a form that has EE ID filed, First & Last Name field, but I'm not sure how to make it so that when I type in an ee's ID, the name pops up on the other field. Please help. Thanks so much!!

 

[Remou]

You have not provided much information. It seems likely that a combobox with several columns of DlookUp whould suit.

 

[New2Tek]

Yea, I want to create a combo box for the EE ID column. So when I select an EE ID, the name on the other column will pop up. Could you help me how to make this happen? Thanks very much!!

 

[Remou]

Use the wizard to create the combobox with several columns. Say you choose ID, Surname, Forename you can set the Control Source of your textbox to:

=[Name Of Combobox].Column(1)

To show the Surname. Note that numbering starts at zero.

 

[New2Tek]

I'm sorry to bother you about this, but could you show me in details what I'm supposed to do? I tried to do what you said, but it didn't work.

 

[Remou]

Have you got a combobox on your form? If you have, cut and paste the RowSource from the property sheet to here. If you have not got a combobox, you need to build one. Tell me if you need help building a combo.

 

[New2Tek]

Ok, this is what I've done so far. I've created a table with 4 columns: Entry # (primary key), EEID, First, Last. I transferred the field names to the form using the wizard. I created a combo box for all fields in the design mode. In the property box, I selected "value list" under RowSource Type, and under RowSource I put all the items I want to include in the box.

Is this correct? I dont know what else to do next. Thanks again for your help.

 

[Remou]

No that is not correct, you need Table or Query, not Value List; it would be better to use the wizard to create the combo box. Furthermore, if your table is already based on the names you want to look up, you need to select "Find a record on my form" from the options presented by the wizard, rather than filling in textboxes. To use the wizard to create a combo, first ensure that the little wand is clicked on the toolbar.