Form drop down box

[Lynnlilyjett]

I am new to Access. When I create a drop down box on a form is there a way to have more than one field from a table appear in the result. Without writing any code I would like 3 columns from the table to appear on my form when I make the appropriate selection.

[Jerry Maiapu]

1.Create a form using wizard. Select table/query followed by the fields you want it to appear on the form.
2.Create a new combo box on the form and follow the wizard.