It's also a performance issue ... if i had a rapid answer from the form my problem is resolved ... Anyone have a ideia to speed up this? All the other form work fine and very fast ...
And i can't use a list or combo box ... the field formando_n_doc is a number and exist almost 10000 in the...
to do what i'm asking for exists this code in one of the fields :
Private Sub formando_n_doc_LostFocus()
Set formando = CurrentDb.OpenRecordset("formando")
Dim controlo As Integer
With formando
Do Until .EOF
.Edit
If Me.formando_n_doc = formando.formando_n_doc Then...
I have a doubt ... I want to write in a field a value and when losefocus i want to do a search for in a particular table and write the result in this field ... how can I do this?
Thanks