Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>Hi Cemal.
>
>>> I use 2 comboboxes for incremental search. In the first searches the user for the id int the second for the name.
>Is this possible with one listbox? <<
>
>Not easily. But now I see what you are trying to do here. It should be pretty straight forward. Can you give me the following information for both combo boxes:
>
>ControlSource
>RowSourceType
>RowSource
>
>And we can figure this thing out.
>
>If the RowSourceType is 2-Alias or 6-Fields, the Bound column of both combos should be the primary key field in the table. Then, in the Valid of the first combo, all you have to do is set the second combo's value to This.Value and vice versa.
>
>Marcia
Hi Marcia,
first combos controlsource is : newline(1)
first combos rowsource is : fields
first combos controlsource : customer.name,id
Second combos controlsource is : newline(2)
Second combos rowsource is : fields
Second combos controlsource : customer.id,name
This code is in the first combos valid event ;
newline(2)=customer.id
Thisform.combo2.refresh
My problem is that the second combo dosent refreshes every time.
Sometime its refresh.
I have chekid newline(2) from the debugger.
Newline(2) is true. But the second combo dont change.
Thanks.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement