Combo box doesn't work properly

[joe1987]

Hi,


I'm facing problem when trying to search for values in combo box. Combo box is placed in 'Main form' and when I'm trying to search for values it gives me wrong result or no result at all. As I understand it might be problem with tabbed form. Can any body give me an idea and suggestion how can I solve this ?
Here is the link for my db download: http://www.2shared.com/file/SRKD0UWS/test.html
J.

[Toyman]

Try this out. The problem I found was there was not code behind the combo box.

[joe1987]

Try this out. The problem I found was there was not code behind the combo box.

Thanks for try, but this didn't solve problem, it doesn't show proper information that you choosed to show through combo box. I think that might be problem of db structure.

[Toyman]

Thanks for try, but this didn't solve problem, it doesn't show proper information that you choosed to show through combo box. I think that might be problem of db structure.

the code I placed was for the search combo box in the front of the form. That is the one in which you select the employee and the form navagates to that page. This is not where you need help on? If it is not, post the the name of the form and the control and describe what it suppose to do.

[joe1987]

the code I placed was for the search combo box in the front of the form. That is the one in which you select the employee and the form navagates to that page. This is not where you need help on? If it is not, post the the name of the form and the control and describe what it suppose to do.

Yes - that's correct, but after you select the name and press enter it navigates you to totally different employee, more - after 3 searches it gives you totally blank form - no results.

[Access_Blaster]

Hi,
I'm facing problem when trying to search for values in combo box. Combo box is placed in 'Main form' and when I'm trying to search for values it gives me wrong result or no result at all. As I understand it might be problem with tabbed form. Can any body give me an idea and suggestion how can I solve this ?
Here is the link for my db download: http://www.2shared.com/file/SRKD0UWS/test.html
J.

Is this what your looking for?

[joe1987]

Is this what your looking for?

I see you wrote code, but it doesn't respond to any action. Did it worked on for you?

[Toyman]

I see you wrote code, but it doesn't respond to any action. Did it worked on for you?

make sure the db in a trusted folder

[joe1987]

Is this what your looking for?

Works perfectly - thank you!!
Toyman - it worked after your advice - thank you too

[Access_Blaster]

Yeah sometimes the DB will not work inside a zip folder. Glad it worked out.