Help Please Combo box updates

[Rick Brandt]

"EdK" <Ed.L.Kramer@questdiagnostics.com> wrote in message
news:084801c34bbf$174ffa60$a001280a@phx.gbl...

> I have a form that I created which has 2 combo boxes, one
> for Sales ID and one for Sales Name. I want to be able to
> choose either sales ID or sales name and have the other
> update. Example, I only have the sales ID # and I choose
> that and then the sales name comes up in the 2nd combo
> box, and vise versa. Is this at all possible? Any help
> would be greatly appreciated.

In the SalesID combo include both columns
Column(0) will be SalesID
Column(1) will be SalesName (you can hide this column)

In the Name Combo do the opposite
Column(0) will SalesName
Column(1) will be SalesID (again, hidden if you wish)

In the AfterUpdate event of SalesID Combo have code like. . .

Me!SalesNameCombo = Me!SalesIDCombo.Column(1)


In the AfterUpdate event of SalesName Combo have code like. . .

Me!SalesIDCombo = Me!SalesNameCombo.Column(1)

You don't say if you are saving this, but just thought I would throw out that this
would normally not be done. You should only save the ID value and use that to
display the name if you need it.

[EdK]

>-----Original Message-----
>"EdK" <Ed.L.Kramer@questdiagnostics.com> wrote in message
>news:084801c34bbf$174ffa60$a001280a@phx.gbl...

>> I have a form that I created which has 2 combo boxes,

one

>> for Sales ID and one for Sales Name. I want to be able

to

>> choose either sales ID or sales name and have the other
>> update. Example, I only have the sales ID # and I choose
>> that and then the sales name comes up in the 2nd combo
>> box, and vise versa. Is this at all possible? Any help
>> would be greatly appreciated.

>
>In the SalesID combo include both columns
>Column(0) will be SalesID
>Column(1) will be SalesName (you can hide this column)
>
>In the Name Combo do the opposite
>Column(0) will SalesName
>Column(1) will be SalesID (again, hidden if you wish)
>
>In the AfterUpdate event of SalesID Combo have code

like. . .

>
>Me!SalesNameCombo = Me!SalesIDCombo.Column(1)
>
>
>In the AfterUpdate event of SalesName Combo have code

like. . .

>
>Me!SalesIDCombo = Me!SalesNameCombo.Column(1)
>
>You don't say if you are saving this, but just thought I

would throw out that this

>would normally not be done. You should only save the ID

value and use that to

>display the name if you need it.
>
>
>.
>Rick,

Thank you very much worked like a charm. I am not one that
usually does things normally. Thanks again.

Ed