text box to combo box

I

Iragalam

I made a form using the wizard and as usual everything was entered as text
boxes. I want to change one of them to a combo box. I used the 'right
click'-'change to' feature, but when i try to see the box options it is just
blank.

Can anyone help with this problem?
 
S

Steve Schapel

Iragalem,

If you create a combobox in that way, then the Control Source property
(which defines which field in the form's underlying table/query the
selection in the combobox will be stored in) will be retained from the
textbox's properties. However, where the combobox's drop down list of
items comes from is defined by the Row Source property. You would need
to go to the property sheet for the combobox and manually enter the Row
Source. There may be other combobox-specific properties that you might
also need to attend to, for example Bound Column, Column Count, Column
Widths, Limit To List.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top