How do I add a field to a form when I've already ran the wizard?

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

Guest

I've already created a form using the wizard. I choose all the fields I
wanted, but now I've added a field to my table. Now I want to add that field
to my form. How do I do that?
 
A form has a Record Source property. This property is generally a query
based on one or more tables. You need to add your new field(s) to the Record
Source query of your form. This will then display the field in the Field
List.
 
open your form in design view. add a control from the Toolbox toolbar; or
from the menu bar click View | Field List, and drag the field name from the
list into the form - a control bound to that field will be created
automatically.

to learn how to perform basic tasks in the software, recommend you invest in
a "user manual", such as Microsoft Access <version> Bible by Prague and
Irwin. it will teach you the basic skills necessary to create a fully
functional database, and give you a solid foundation on which to learn more
advanced design techniques.

hth
 
I've already created a form using the wizard. I choose all the fields I
wanted, but now I've added a field to my table. Now I want to add that field
to my form. How do I do that?
Click to expand...

Open the Form in design view. View its Properties; find the
RecordSource property on the Data tab. Click the ... icon by it. Make
sure the new field is included in the recordsource query.

The field will now be available in the List of Fields control (use the
View menu option to display it). Drag the fieldname onto the form; or
use the Toolbox Wizard to add a control (textbox, checkbox, combo,
whatever's appropriate) to the form.

John W. Vinson[MVP]
 
Back
Top