By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Filter records based on a combo box selection

P: 6
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 :-)
Nov 3 '06 #1
Share this Question
Share on Google+
6 Replies


PEB
Expert 100+
P: 1,418
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 ;)
Nov 4 '06 #2

P: 6
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!
Nov 10 '06 #3

MSeda
Expert 100+
P: 159
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
Nov 10 '06 #4

PEB
Expert 100+
P: 1,418
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!
Nov 19 '06 #5

P: n/a
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...???
Oct 1 '10 #6

100+
P: 131
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
Attached Files
File Type: zip Records2003.zip (19.3 KB, 1857 views)
Oct 1 '10 #7

Post your reply

Sign in to post your reply or Sign up for a free account.