RE: [MS_AccessPros] QUESTION ON COMBO BOXES

Edgar,

Again, please use UPPER and lower case letters. ALL UPPERCASE IS CONSIDERED SHOUTING.

The Row Source of a combo box is typically a SQL statement or query. You can filter the results of this query by referencing the primary key field value of the customer table in the criteria.

If you can't figure this out, come back with information about your form's record source and the Row Source of the combo box.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: xtintores@yahoo.com
Date: Fri, 3 Jun 2011 03:03:20 +0000
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]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/