edit form after changes to fields

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

Guest

I'm new to Access. I'm using version 2003. I created my tables and linked
them and then used the wizard to create my form. Since then I've made changes
on the tables such as adding new fields and adding additional selections in
some of the pull-down menus. Now I want to edit my form to reflect these new
changes to the fields. When I open the form in design mode I click on the
field list at the top but my new fields aren't on the list. Nor have the
pull-down menus been updated on the form for the fields I added to. How do I
update my form?
 
If you are using a query for record source for the form then you need to add
the fields in the query.
If you are using a select statement in the form then you need to add the
fields in that statement.
 
Karl,
Thank you for taking the time to help. Unfortunately your response does not
make any sense to me. I am not doing a query nor am I creating any
statements. I am trying to get edit the design of an existing form. I am
trying to display fields on the form which have been created on tables
subsequent to the initial creation of the form. I am also trying to get some
of the fields already displayed on the form to show the additional options I
have added to their pull down menus.
-Sarah
 
A form has a Record Source where it gets the table & field information. No
matter how the form was created, in design view or by wizzard, it will only
list those that existed when it was created unless the record source select
statement used a wildcard to select all fields.
Open your form in design view, click on menu VIEW - Properties and see what
is the listed record source. That source will need to be edited so that the
fields will be available to use in the form.
How did you add options to the pull down menus?
 
To add more choices to the pull down menus I did the following:
In the table in design mode I clicked on the lookup tab at the bottom of the
screen. I then typed the new selections in the Row Source section. I saved
them. When I am in the tables I can see the new selections, but when I'm in
the form the selections have not been updated.
-Sarah
 
I never use the lookup in the tables as you will find much advice against it.Open you for form in design view, view the properties of the
Listbox/Combobox (used for your pulldowns) and see what is in the Row Source.
 
Back
Top