Combobox-Basics

[Ricardo]

Another easy question

* I have a table "X" with 5 differents alternatives of products
* I have a formular and I would to have a combobox that displays this differents alternatives
* When I choose Product A , B, C, D or E this data goes to other table "Y".
Someone could help me??
I know is easy...
thanks
ricardo

 

[bat17]

Use the wizard to build the box for you and it will do this automaticaly providing that the form is bound to table Y

1, Select "I want the combo box to lookup the values in a table or query" click next.
2, select the table that hold ABC, click Next.
3, select the field that hold ABC, click Next.
4, Set column width, next
5, Select "Store value in this field" and select your field to save the data to in table Y, next
6, give it a sensible name and Finish


HTH

Peter