Combo box Problem

[reno.04]

Hey all
If i have a form with a combo box's control as ID and then a txtbox with a
control of first name

How do I get the first name of the selected ID to appear?

cheers

Reno

 

[Gerald Stanley]

The first thing you would need to do is to change the
combo's RowSource SQL to retrieve the firstName as well as
the Id. You will also have to change the column count to 2.

Then in the combo's AfterUpdate eventhandler, you could put
in code along the lines of

myTextBox.Value = myCombo.Column(1)

You will need to change myTextBox and myCombo to suit your app.

Hope This Helps
Gerald Stanley MCSD

 

[Ninkasi]

I'm having a problem with this aswell..

Could you tell me in step by step how to do this??
Cheers,
..::// Ninkasi \\::.

 

[Ninkasi]

I'm having a problem with this aswell..

Could you tell me in step by step how to do this??
Cheers,
..::// Ninkasi \\::.