Search Form Problem

[chrisb1981]

I have got a search form based on Allen Brownes Find As You Type. I have put the following code into the Dblclick event for all fields:

RecordID = RecordID
DoCmd.OpenForm "SalesForecast"
DoCmd.GoToControl "RecordID"
DoCmd.FindRecord RecordID
DoCmd.Close acForm, "Search"

And I am running into problems as it does not work.

The search form works as it should but the double click event does not.

When I added the Double Click code into the FindAsYouType example DB the code works fine the only thing I have changed is in the working sample RecordID is CustomerID.

Could someone please point me in the right direction as I am really stuck on this.

 

[chrisb1981]

I have fixed this now. The problem was recordID was an autonumber field I changed it to a different field and it works fine