(HOW)Opening forms from search result

[mikey222]

Greetings

I'm trying to allow users to double click the products from the search results to open the individual product forms. Attachment is the file that im working on. Anyone would be kind enough to help out Appreciate...

i tried to upload the access file through this website but it doesnt work....
here is the link (2.94mb)

http://www.yousendit.com/download/Y2orSkhYcVhENlR2Wmc9PQ


access 2007 version

Thank you very much

 

[RuralGuy]

I get an Oriental font in some areas of the db. Was that intentional or is there some corruption? What form were you trying to open?

 

[mikey222]

o i'm very sorry my access is in chinese maybe that is why my fonts are all in oriental...i'll fix it and upload it again...thanks for the attempt

cheers

 

[RuralGuy]

Just post back here when you are done.

 

[mikey222]

here is the new link of the file, i've changed the font and it should be fine.

Thank you for your patience and looking foward to your reply ^^

http://www.yousendit.com/download/Y2o5MFh0dENqV0JFQlE9PQ

 

[RuralGuy]

Can you compile your db? I get errors when I try. I also get errors when trying to run the search form. What form are you trying to open with a double click, the Products form? It looks to me like you are trying to open something called frm_SearchEngine which does not exist in the db.

 

[mikey222]

Sorry about the errors...ignore the searchengine code i was just playing around with it.

Basically i would like to have the users to double click the items on the search list (the picture above)

For instances, if i double click the item FB4409, the FB4409 form will pop up from the form Products.

I'm a novice on writing codes...i copy and edit the codes from examples and the search form works on my computer. How do i compile the file so you can open it without error?

 

[RuralGuy]

When you open your Module1, go to Debug>Compile. It should complete without any errors.

 

[RuralGuy]

This is just a start but see if it is something like you wanted.

 

[mikey222]

thanks rural that is exactly what i want

appreciate the help

cheers

 

[RuralGuy]

Glad I could help.