Adding new field to form

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

Guest

I created a form using the wizard and combining info from 3 different tables.
Unfortunately, I forgot to include a necessary field (hence, it's not
included in the field list), which I now would like to add to the form.
However, it's not included in the field list and I don't know how to add it
to the field list.
 
1. Open the form in design view
2. Go to the form properties, by clicking on the top left corner of the form
3. Go to the recordsource property of the form, click on the button on the
right that has three dots
4. Now the SQL is open, that include all three tables, add the fields you
want to include from the right table
5. as you exit the query, it will ask you if you want to save, say yes
6. Before closing the form, save the form, it might close without saving

If the form is based on a query, then you can open the query in design view
and do only 4 and 5 stages
 
I created a form using the wizard and combining info from 3 different tables.
Unfortunately, I forgot to include a necessary field (hence, it's not
included in the field list), which I now would like to add to the form.
However, it's not included in the field list and I don't know how to add it
to the field list.
Click to expand...

The form's record source is a query.
Open the form in design view.
Display the Form's property sheet.
Click on the Data tab.
Click on the RecordSource line.
Then click on the button with 3 dots that appears on that line.
The tables are shown in the top portion of the query grid.
Find the table that the wanted field is in. Select the field from that
list and drag it onto the query grid.
Save the change.

The new field will now appear in the Form's Field List.
 
You don't need to add it to the field list. Open the form in design mode.
Create a text box (or whatever type of control you need). Open the
Properties drop down. Click on Control source and you sould be able to
select the field from that list. If you don't see it, just type the name of
the field into Control Source.
 
Back
Top