TextBox filled with the filter of a combobox

S

Sam

Hello everyone

I have a combobox (Name - Combo10 ; Controle Source -
CDoente) where i retrieve the number of a patient to be
saved in my table, based on a query (Cdoente (number) -
Doente(Name) )

I also have a Textbox (Name - Text21 ; unbound) that i want
to fullfill with the name of the patient that is not to be
saved but for information only.

After i fill the combobox with the number of the patient i
want by Dlookup to lookup on table TDoentes the name of the
patient(field - Doente) based on the number i have on the
combobox.

Until now i couldn't do it. it only retrieves the record
with CDoente = 1. All the others don't appear.

Could someone help me????
 
Top