Filter records based on a combo box selection

[Kazza]

Hi
I'm using Access 2003 and I need to figure out how to display the record details based on a combo box selection. For example, when I select a company name in a combo box, how do I get the related customer name and other relevant information, such as:
Company contact
Delegate name
Delegate ID
Delegate Discipline
Course date
Course location
Course requirements
to appear so the result show x of x records?

I really DO NOT understanding the programming side of things, so if this can be done, can someone pleeeeeeeeeeese tell me in plain easy to understand instructions.
Thank you
Kazza :-)

[PEB]

Hi
I suppose your combo box is in a form...

This combo box has his own name...

Create a query that shows the information you need and above the company name type with your respective names

=Forms![YourForm]![YourcOMBObOX]

Open your query and it's ok...

To open it immediately....

You should use a macro... that opens query Can you figure it alone?

Than put this macro in the after update property of your combo box...

And your baby is ready ;)

[Kazza]

Hi
I suppose your combo box is in a form...

This combo box has his own name...

Create a query that shows the information you need and above the company name type with your respective names

=Forms![YourForm]![YourcOMBObOX]

Open your query and it's ok...

To open it immediately....

You should use a macro... that opens query Can you figure it alone?

Than put this macro in the after update property of your combo box...

And your baby is ready ;)

Thanks for the reply, but to be honest its all double dutch to me - i do not understand marcros etc and when ever I have tried to set on up it has gone wrong :-( I am looking for assistance, but i think i need to understand the basics first - so i had better start reading!

[MSeda]

Tha access query wizard will make just what you want. make a form based on the table or query with the data you want to disply. then before you make the combo box make sure the wizards are turned on, there is a little magic wand thingy on the tool bar usually to the left of the textbox and label buttons. press this and it will stay kind of highlighted looking now when you press the combo button on the tool bar it will open the combo wizard. access will take it from there

[PEB]

Hey, people don't be scared...

You need to put just this line

=Forms![YourForm]![YourcOMBObOX]

in your query criteria!

And this is all

Forget the macros.. they are for perfectionistes...

Thanks for the reply, but to be honest its all double dutch to me - i do not understand marcros etc and when ever I have tried to set on up it has gone wrong :-( I am looking for assistance, but i think i need to understand the basics first - so i had better start reading!

[weat]

If you put the line =Forms![YourForm]![YourcOMBObOX] in the criteria of the query, you just get a parameter box labelled with that double dutch...???

[Mr Key]

Hi Kazza!
may be I dont know exactly what you are looking for, but you may try this attached database below! It may give a hint to start with. Open the DB and then read carefuly THE attached AFTER-UPDATE Procedure and try to implement what has been there at the AfterUpdate Event.
Should you have any doubt dont hesitate to ask again! Mark it as answered if it has