View Full Version : Combo box for data entry in form


cinnamoncw
03-15-2000, 08:53 AM
I have a database that maintains clothing inventory information. There are numerous fields for each product, such as item type, color, size, etc. Is there an easy way to use a combo boxes to narrow the search for a product, starting with the first combo box choosing an item (Pants, jackets), then the second combo box showing the color for the specific item, etc? I do not know VB...Thanks!

Travis
03-15-2000, 11:25 AM
Create your form with combo boxes (one for each item you wish to have as a criteria)

Next create a query using the combo boxes as the criteria for its associated field: Your criteria will look something like this:

=Forms![frmYourSearchFormName].[CriteriaComboBoxName]

cinnamoncw
03-15-2000, 12:02 PM
Is this similiar to a Dialog Form? I have had success with those in creating reports based on criteria...Is there a way to use these forms to enter criteria in a Data Entry Form (i.e., customer orders Item1 in Red) and have this automatically recorded in an Orders Table for the Customer?