HELP!!! URGENT!!!!

[JasonLiew]

Hi ppl,

I'm currently facing a little problem and I try hard enough to find the solution. Can I Seach and show 2 different information in a single form? Wat I mean is I have 2 dropdown box and when I click on dropdown box A then it will show A's information at Subform A. When I click on dropdown box B then it will show B's information at Subform B. All in 1 form.... Can it be done...? Need help urgently...

 

[JasonLiew]

Hi, I have successfully retrieved 2 diffrent data. But when I onclick on my dropdown box, it show me an error message which is "Run time error '3070': The microsoft Jet database engine does not recognize 'Job_#' as a valid field name or expression" Job_# is my field name. I have tried changed my field name and it also appear the same message. Can you help me?

 

[hermanlaksko]

Try [Job_#] should do the trick.
But in future use more commen field names ;-)

 

[JasonLiew]

Thank you very much.
Its done!
Thank you.

 

[THoey]

Jason, glad you got it working. Just wanted to suggest to you that you be more descriptive in your thread titles here on Tek-Tips. I have been told that a lot of the members here won't open a post with a title something like "HELP". Try to briefly explain or catagorize the problem in the subject. It helps us to know if we can help you or not...

Thanks, and again, glad you got your problem fixed... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...