COMBO BOX - 2ND VALUE

  • Thread starter Thread starter Samora
  • Start date Start date
S

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
 
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)
 
Back
Top