Match one column data with data in the second column

[impuce]

I don't know if this can be done but I have a table with columns named Manager, Employee, EmpNum.

In a form created from the table, I have a 2 dropboxes, Manager and Employee.

How do I auto-populate a textbox with the EmpNum of the name chosen from the Employee dropbox?



It would be the same as a Vlookup in Excel.

[madpiet]

I don't know if this can be done but I have a table with columns named Manager, Employee, EmpNum.

In a form created from the table, I have a 2 dropboxes, Manager and Employee.

How do I auto-populate a textbox with the EmpNum of the name chosen from the Employee dropbox?

It would be the same as a Vlookup in Excel.

You have to add the EmpNum to the dropdown's rowsource. "SELECT Employee, EmpNum FROM SomeTable"... and then in the controlsource for the textbox, you'd refer to the combobox. =Me.cboEmployee.Column(0)

[impuce]

Hi,

Did has you mentioned. Changed "SomeTable" to the table I'm getting data from.
The textbox come up with an error #Name?

[Micron]

EmpNum would be column(1) in the suggested rowsource. Why do you need a textbox when you can display the num in the combo? Or do you need to see both on the form?

[madpiet]

Well, in fairness, you said you have "a table". I'm not psychic, so I didn't know the name of the table.

Want a good answer? Ask a good question, including all the relevant details.

[pbaldy]

=Me.cboEmployee.Column(0)

"Me" is invalid outside VBA, the reference would be:

=cboEmployee.Column(0)

More here:

http://www.baldyweb.com/Autofill.htm

[Micron]

Good catch.
Someone needs to take a chill pill?

[pbaldy]

Someone needs to take a chill pill?

I had a similar reaction.

[impuce]

EmpNum would be column(1) in the suggested rowsource. Why do you need a textbox when you can display the num in the combo? Or do you need to see both on the form?

I changed the (0) to (1) as it was the second column I needed. Still getting the same error. I even remove the "Me.", still the same.
The reason I don't display the num in the combo is because depending on what the first number is, it goes to different departments.

[impuce]

"Me" is invalid outside VBA, the reference would be:

=cboEmployee.Column(0)

More here:

http://www.baldyweb.com/Autofill.htm

Still getting the same error.

[pbaldy]

Can you attach the db here?

[pbaldy]

Oh, and is cboEmployee the name of the combo box?

[Micron]

The reason I don't display the num in the combo is because depending on what the first number is, it goes to different departments.

Unfortunately that doesn't clarify anything for me. You can have as many columns in a combo list as you want, and retrieve any column value from the chosen list item. What you see is the 1st visible column. Putting a name or number in another control when you already have a control that contains it (or could) is a bit odd to me - unless as I mentioned, you need to display more than one column value at the same time on the form.

[impuce]

Oh, and is cboEmployee the name of the combo box?

That worked!

Thank you!

[pbaldy]

That worked!

Thank you!

Happy to help!