Questions on List and Combo Boxes

[Chloe78]

Here's the deal. I have experience with Access, I basically know what I'm doing for the most part but my main question is this..because I cannot seem to find the answer anywhere. When you are in design view of the form--is it possible to change a certain field to a combo box (I know it is) but how do you make it contain the items that you want in the combo box, i.e. salesman names for example. Or do you have to do this directly in the table and if so how. Sorry if this is such a mundane question but I cannot figure it out for the life of me. Thanks everyone.

Chloe

 

[RoyVidar]

Hi!

At least in A2K it's possible. In design view, right-click the control you want to change, on the Format-menu, choose "Change to" and click the appropriate control type

Right click your new Combo-control and click Properties, select the data-tab and there specify whether you want Value list (then type your values in the RowSource field) or table/query.

If you select table/query, then the "Build-button" should be available on the right side of the rowsource-field. Choose it to build the combos rowsource through the query-design-grid.

Hope I'm answering your question, Roy-Vidar

 

[Chloe78]

Thank you Roy.

I am trying it now!!!

Chloe.

While I'm asking questions..how do you link forms to other forms??

Then that should be the end of my access woes.

Thanks again,
Chloe