How to add Column into form

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

Guest

I already have form with multiples Column but I like to add one more. Help files don't help me. Please advise in simple way.
Thanks
 
Hafeez said:
I already have form with multiples Column but I like to add one more.
Help files don't help me. Please advise in simple way. Thanks
Click to expand...

You don't give much information to go on, but I'll try.

Presumably the form is based on a table or query. The column you want
to add to the form must first have been added as a field to the table,
and that design change must have been saved. Then, with the form open
in design view, click the "Field List" button on the toolbar, or clck
menu item View -> Field List, to display the field list. Look in the
field list to see if your new field is there. If it is, just drag it
onto the form, and then adjust the properties of the resulting control
to make it look the way you want.

If the new field isn't in the field list, close the field list and open
the form's property sheet. Go to the Data tab of the property sheet and
click on the line for the Record Source property. A "build" button,
with the caption "...", will appear at the end of the line. Click that
button. The form's RecordSource query will open in design view. Edit
that query to include the new field in the fields that it returns, then
close the query design window. If it asks you if you want to save the
query and update the property, say yes. Now the field should be
available in the field list, and you can drag it down onto your form.
 
Back
Top