Dlook up Problems (1 Viewer)

I am trying to populate a txtBox on the SubForm of a Form, Using a Set Value Function = DlookUp function. The DlookUp Function searches for a value in the table and compares it to a value of another txtBox of the subform .
The problem is:
Using the Left Switch on Mouse works fine, txtBox is populated correctly
Using the Enter Key does not work; it clears the box used for the seaech data and does not populate the txtBox.

I tried placing the procedure in the After Update event and also placing it in the on Enter event to no avail.

Suggestion are very welcome
thanks a bunch

Otto

odrozd said:

..

Using the Left Switch on Mouse works fine, txtBox is populated correctly

Click to expand...

Do you mean, setting focus to another control or???

odrozd said:

Using the Enter Key does not work; it clears the box used for the seaech data and does not populate the txtBox.

Click to expand...

Is the textbox unbound, normally an Enter shouldn't clear anything, (only set focus to an other control if there are any)?
Show all your code for that textbox!