Automatic insertion of the value of a field in a form.

[habiler]

Hello everyone,

I have a form that when I insert a registration number I would like the value of the field "nom" the name automatically appears in the "nom" field of the form.
The form uses a query.

 

[pbaldy]

Can't look at the sample right now, but is this appropriate?

http://www.baldyweb.com/Autofill.htm

 

[habiler]

In fact I have two tables ave in table A [matr], [name], [prenom] and a second table B with [matr], and to the query: nomPrenom: Trim ([nom]] & "" & [prenom ]). I would like in shape when I hit a [matr] (table B) the nomPrenom (query but from table A) appears in the form.