Problem in displaying control from databse to form automatically

[ashish_access]

I have created and saved a form in access automatically from database table.But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.


Please suggest me some solution.

[June7]

Changing the field in table to have a combobox will not reflect in control already created on form. You will have to convert the control to a combobox and manually edit properties or delete the textbox and drag the field from field list to form which will adopt the properties of field.

[Missinglinq]

A Lookup Field in a Table is considered to be a very bad idea by many experienced Access developers, especially when done by inexperienced developers! For the reasons why read the article "The Evils of Lookup Fields in Tables" here:

http://mvps.org/access/lookupfields.htm

Note that this refers to Lookup Fields/Comboboxes in Tables not to Comboboxes in Forms, being used to lookup Records. That is something else all together.

Linq ;0)>