farmer1

Ok so I designed my table had all the fields set up as text. Then designed the form.

I then decided to go back and change the table design so that the text fields had dropped down lists?

Now is there anyway of getting the form to automatically update the fields rather then having to re-design the forms again?

bob269

In design view, try right clicking the text box and click Change To >

farmer1

Tried that but the field no longer remains linked to the one in the table

bob269

Did you not get the option to update all forms when you updated the table.

How about on the form, right click on text box, properties then select the control source again?

farmer1

Yeah thats what I have done in the end.

No never had an option to update all forms when I updated the table.

Was hoping there would be a 1 click button to update, done them all individually now. Thanks anyway

bob269

For future reference the second you change any parameters in a table the lightening bolt should appear, click this and it will give you the option to update all dependicies of the field.