Adding a new field to a form?

  • Thread starter Thread starter FreisingSean
  • Start date Start date
F

FreisingSean

Hi, I have been using Access for about a week and have hit a brick wall..

I have created my tables & from these a form. I'm very happy with what I
have done so far and it serves about 80% of it's original purpose.

I would now like to amend my form by adding 2 new fields:

How do I do this, without destroying what I have already done?

Thanks
Freising
 
You need to first add your fields to the table. Fields only exist in
tables.

Once you've saved your table changes, then you can open your form in design
view. Display the field list and drag the new fields from the list to your
form.

If your fields don't show up in the field list, then your form is based on a
query/SQL statement and not on your table. In this case, go to the Record
Source property of the form, and modify it to include the two fields.
 
FreisingSean said:
Hi, I have been using Access for about a week and have hit a brick wall..

I have created my tables & from these a form. I'm very happy with what I
have done so far and it serves about 80% of it's original purpose.

I would now like to amend my form by adding 2 new fields:

How do I do this, without destroying what I have already done?

Thanks
Freising
Click to expand...

Fields belong to tables. You put controls on a form which can be bound to a
field. Open your form in design view and click the "field list" toolbar
button, then just drag 'n' drop.

Keith.
www.keithwilby.co.uk
 
Hi, I have been using Access for about a week and have hit a brick wall..

I have created my tables & from these a form. I'm very happy with what I
have done so far and it serves about 80% of it's original purpose.

I would now like to amend my form by adding 2 new fields:

How do I do this, without destroying what I have already done?

Thanks
Freising
Click to expand...

A Form does NOT contain fields, and does NOT contain data. A Form is just a
window, a tool to let you work with data in Tables.

Open the table in design view, and add the fields there. Be sure you have the
correct datatype. The fields will be NULL in those records where you already
have data, you may need to run an Update query or fill them in manually if
they need to be filled.

Then open your Form in design view. View its Properties. On the Data tab the
first property should be the Recordsource (where the form gets the data to be
displayed); click on the ... icon by this, and a Query window will open, maybe
with a prompt asking if you want to see the query window (say yes). Add the
newly created fields to the query window and close it. Accept Access' offer to
save the query.

Your new fields can now be added using the Field List tool on the toolbar, or
by using the Toolbox to add a new textbox, or checkbox, or whatever would be
the appropriate control.
 
In addition to the other advice, you don't say which access version you are
using, for Access 2007, with the form in design view, the Design Ribbon
contains the tools menu and at the extreme right of that ribbon, you will see
"Add Existing Fields.", drag and drop to add these existing fields as
controls on your form.

Hope this helps
 
Back
Top