|
Try This: Do the following steps
2. Create a new Table with the command
Create->Tables->Table Design.
3. Add the following Fields and Data Types:
4. Save the Table as tblType.
5. Go to Datasheet View.
6. Add the following to the Type column:
7. Open the Form Products and switch to
Design View.
8. Delete the Type Box on the Form.
9. Go to Form Design Tools->Design and
select a Control: Combo Box.
Add the Combo Box to the form where the
Label Type used to be.
10. Choose the option to get the Combo Box
values from another source.
Select tblType as the source. Select all
available fields.
11. Select the Field Type to sort
Ascending.
12. Do NOT hide the Key column. Instead,
resize the TypeID column to width zero.
13. Select a field to store: choose Type.
Store the value in field Type.
14. Name the Combo Box: Type and finish the
Wizard.
15. Change to Form View. Test the Combo
Box. Does it display five types of products?
16. Return to Design View. Select the Type
Combo Box and open the Property Sheet.
17. Change the Combo Box name to TypeCombo.
Set the column widths to be 0”, 1.25” |
|
| |
