double click open record problem

[antonyx]

greetings all..

i have tried to use an old database template i had and re-work it for my new client..

basically the user types a ref no into a search box.. there is a text list that is narrowed down to the chosen item as they user types..

then they double click on the item in the list and it opens in the main form..

this is how it should work.. i think im pretty close but im gettin a few problems.. i would be very grateful if someone could have a look at it...

the form i want all this to happen on is called MAINFORM.. the database is very simple.. one table.. one query.. thats it..

thanks..

 

[antonyx]

sorry, here is the link for the database

http://bb.1asphost.com/antonyx6/properties.mdb

 

[ScottGem]

Why not just use the combo wizard to create a search combo in your form header?