The technique used to filter the contents of a "downstream" combo box (like
Contacts) so that it is populated with only contacts belonging to a customer
selected in an "upstream" combo box is generally referred to as "Cascading
Combo Boxes". There are many good examples of this technique on various
websites, if you Bing for them by that term.
Here's one. http://www.candace-tripp.net/Pages/Main.aspx?cat=demo Look for
the download on this page with the name .Cascading Combo Boxes Database
George Hepworth
PS: TYPING IN ALL CAPS IS CONSIDERED SHOUTING, AND GENERALLY NOT A GOOD WAY
TO COMMUNICATE.
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
rivera_vazquez_edgar
Sent: Thursday, June 02, 2011 8:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] QUESTION ON COMBO BOXES
IN A CUSTOMER INFO FORM, CAN I MAKE A COMBO BOX THAT ONLY DISPLAYS THE
DIFERENT CONTACTS FOR THAT CUSTOMER, EVEN IF I HAVE TO USE A SEPARATE BUTTON
TO OPEN A DIFERENT FORM TO ENTER THE DIFERENT CUSTOMERS? IF SO, HOW DO I
SPECIFY THE COMBO BOX TO JUST DISPLAY THE CONTACTS RELATED TO THAT CUSTOMER?
EDGAR
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar