Adding new Fields to Forms

  • Thread starter Thread starter -- Paul --
  • Start date Start date
P

-- Paul --

Some help Please

I started to create a mail merge in word and got to the point where you
enter names and address etc. Rather than finish the merge though, I saved
the data I had added and closed word.

I then opened the data file of names and addresses I had just entered which
opened in Access and I created a form using a wizard.

I then went into table design mode and added two extra fields - one was
called ref and contained autonumber and was the primary key. The other
field was just a memo field for notes.

I now need to go back to forms in design mode and add the Ref field and
Notes field. Can someone please explain how I do this? I assume I don't
need to redisgn the form from scratch so it incorporates the two additional
fields? The new fields are not shown in the button labelled 'field list'.

Thank you
 
Check the underlying query or data source in the properties of the form.
The fields may simply need to be added to the query. Once they are in the
query, they will appear in the button "field list", then you can drag them
onto your design grid. Good luck. Hope this helps.
 
The form design wizard uses either a table or query to create the form,
depending upon which is the active object in the database window when the
wizard is started. If you were in query mode, (you can tell by looking at
the recordsource of the form in design view) open the query and add the
field to the query. It will then show up in the form's field list.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Excellent Thanks

Arvin Meyer said:
The form design wizard uses either a table or query to create the form,
depending upon which is the active object in the database window when the
wizard is started. If you were in query mode, (you can tell by looking at
the recordsource of the form in design view) open the query and add the
field to the query. It will then show up in the form's field list.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 
Back
Top