How do I update a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a form. I had to go back and modify the table from which it was
pulling. (changed on text box to a yes/no check, and added a field). I can
not get these changes to be reflected in my form without redoing the entire
form. There has got to be an easier way.

Thanks
 
first of all check if in the form [properties/data] recordsource is selecting
every field of the table you are working with.
then delete the textbox and replace it with a chechbox and make sure the
[properties/data] controlesource of the checkbox is the (Yes/No) field.
then add a textbox and do the same as with the checkbox [properties/data]
controlesource is the field you want to display.
if you dane this it should work.

GReatings,
Harm Ozinga
 
DDrowe said:
I have built a form. I had to go back and modify the table from which it was
pulling. (changed on text box to a yes/no check, and added a field). I can
not get these changes to be reflected in my form without redoing the entire
form. There has got to be an easier way.


The easier way is to open the form in Design View. The
wizard you have been using is a convenience for getting a
quick start in creating a form, but it just gets in the way
once the form exists.

Once the form is opened in design view, be sure to display
the Property Sheet (View menu) so you can see all the things
you can set for the selected item, either the form itself or
any of the controls on the form. There is also the Tool Box
tool bar where you can choose the kind of control you want
to add to the form. More to the point of your question, you
will probably want to display the form's Field List (View
menu), which allows you to drag a field from the list to the
form and have a control created automatically.

Those features are only the highlights of the extensive
editing features that you can use to fine tune a
form's/report's design, so check out Keyboard shortcuts and
the other toolbars/menu items that appear when in design
view.
 
Back
Top