control event problem on keyboard return key

[Costefran]

Can someone help with this one

I have a combo box called [name] with a list of names that sets the current date on another control called [date] on the [name]afterupdate event
If the user selects a name from the list it works fine

If the user uses the autofill facility by typing in the first few letters in the [name] control and then presses the return key on the keyboard, the date does not fill (the code is not executed) Perhaps I should be placing the code in another event on the [name] control but not sure which one

Thanks

 

[PHV]

I don't see any autofill property for any access object !

 

[Costefran]

Aposlogies - I have called it autofill and shouldn't have

To explain

The row source for the control is based on a query and the control is set to limit to list if the user types in one letter in the control then the control starts automatically populating the control with the first relevant item in the list

As stated, when they do this and press the return key then my after update code is not executed so assume the code should be entered in another event associated with the control

Hope this explains things

 

[PHV]

OK, you talked about the AutoExpand property.
What about the Change event procedure ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Costefran]

PHV

Many thanks

Have tried the change event procedure and this doesn't seem to work

 

[PHV]

And the LostFocus event ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Costefran]

PHV

Many thanks the lost focus event works fine