Forms

[TaylorLeigh]

I have a field on a form that is supposed to have a drop down list, but it
does not even show a drop down arrow. If I look at the table, it is ok.
What did I do when I created the form that made this disappear.

Thanks,

 

[John W. Vinson]

I have a field on a form that is supposed to have a drop down list, but it
does not even show a drop down arrow. If I look at the table, it is ok.
What did I do when I created the form that made this disappear.

Thanks,

Open the Form in design view. Select this control. Is it a Textbox or a Combo
Box? If it's a textbox and you want a dropdown, either right click it and
select Change To..., or just delete the control and use the Toolbox wizard to
add a new combo box.

 

[Maurice]

I don't know what made it disappear but why don't you make a combo out of it
yourself. If the controlsource is right change the textbox to a combobox by
rightclicking it and choose the apprpriate option. Set the properties for the
combo to your whish.