I have created a combo box in a form. When I select a value for the first
form - that value appears for all the forms in database view. Why is that?
Is it possible to convert an existing field box to a combo or list box?

Signature
Thank you kindly
Wayne Morgan - 01 Sep 2005 02:54 GMT
Is the form in continuous or spreadsheet view and the combo box unbound? If
so, it will do that because there is really only one combo box. Without a
bound record to change what it displays, when you make a selection the same
selection will appear in each record. The same thing will occur in single
form view, it's just that you don't see it until you go to the next record
and notice that the combo box still has the last selected value in it.

Signature
Wayne Morgan
MS Access MVP
>I have created a combo box in a form. When I select a value for the first
> form - that value appears for all the forms in database view. Why is
> that?
> Is it possible to convert an existing field box to a combo or list box?
Marc - 01 Sep 2005 02:56 GMT
<snip>
"shoiley"
>I have created a combo box in a form. When I select a value for the first
> form - that value appears for all the forms in database view. Why is
> that?
> Is it possible to convert an existing field box to a combo or list box?
Do you mean the first record? Then yes, that is the way it works. Rather use
continuous forms.
HTH
Marc