Brian Blandford wrote:
After I successfully created an address book in base with table, form,
and queries all functioning correctly, I realised there was an
additional field I wanted to add. I opened the table and added an
extra column for the new field. However, I can find no way to
incorporate the new field into the form. I open the form in design
view, I draw a text box, then click on the control button, then look
in the "label field" list on the Properties dialogue that pops up, but
the new field is not included in the list.
How do I get the new field onto the form?
The "Help" files don't help for editing existing databases as far as I
can see.
Hi Brian,
Assuming that your form is based on the table, and not a query, then.
Open the form for editing.
Be sure the Form Design toolbar is open and on it click the "Add Field"
tool button ( sixth from the left ). This opens a tool window with all
fields, including your new one, displayed.
Drag and drop the new field name from the tool window to the form, both
a label and control box will be added to form, grouped.
ps - if you have done this and the tool window was empty - that is
because it changes field lists as you select different controls from
different record sets ( ala a Form/Sub-Forum layout ) in this case you
just need to click on one of the existing controls on the form and it
will fill with the field anems.
If your form is based on a query, other then SELECT * FROM TABLE then
you must open the query in edit mode, add the new field to the result
set and save edit.
Then follow the instructions above.
I HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
