COMBO BOX - 2ND VALUE

23 Feb 2005 3:51 PM

Samora

Hello

Good afternoon

i have a Combo box that retrieves me a value CODSAUDE from
a table (TCodigos) and placed it on field CodCSaude of
table TDet.

this i had allready done and is OK.

However i want that after update this field , CodCSaude
lookup on Table TCodigos and retrieves field ValFranq from
TCodigos and put it on the field ValorPagar from TDet.

How can i do it?? Is it possible or do i have to code it ?

Can anybody help me, please.

Thanks in advance

Best regards

23 Feb 2005 4:35 PM

PC Datasheet

Your combobos needs to be based on a query based on TCodigos. The query
needs these fields in this order:
ID
CODSAUDE
ValFranq

Set these properties for the combobox:
BoundColumn 1
Column Count 3
Column Width 0;1,0
Adjust the "1" width as needed

Put the following code in the AfterUpdate event of the combobox:
Me!ValorPagar = Me!NameOfCombobox.Column(2)

--
                                        PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                              resou***@pcdatasheet.com
                                 www.pcdatasheet.com

Show quote

"Samora" <anonym***@discussions.microsoft.com> wrote in message
news:173601c519bf$97ab6fd0$a501280a@phx.gbl...
> Hello
>
> Good afternoon
>
> i have a Combo box that retrieves me a value CODSAUDE from
> a table (TCodigos) and placed it on field CodCSaude of
> table TDet.
>
> this i had allready done and is OK.
>
> However i want that after update this field , CodCSaude
> lookup on Table TCodigos and retrieves field ValFranq from
> TCodigos and put it on the field ValorPagar from TDet.
>
> How can i do it?? Is it possible or do i have to code it ?
>
> Can anybody help me, please.
>
> Thanks in advance
>
>
> Best regards
>