Can an additional field be added ? 1

[kat25]

Hi All,
I have a form that I need to add another field to the form and to the source table. My question is, can I add the field to an existing saved table and form without causing any problems to the table/form?
The table curently has a relationship with another table,but
the field I want to add is not a primary or foreign key field.

Thank you.

 

[LittleSmudge]

You can add fields to tables at will

You go into the tables tab of the database window and select the table then click on DESIGN

Then you can add rows to the layout you see.


HOWEVER - You can't ( You don't want to ) add FIELDS to your Form

You add CONTROLS to your form.

h the form in design view you can display the toolbox by clicking on the toolbox button on the toolbar.
Then click the type of control you want to add
Then click and drag on the form in the place where you want the control to be.
Then activate the properties dialog box.
In the ControlSource property - put the name of the field that you want to bind this control to.
In the Name property change the name to something meaningful - usually the same name as the field name - but it doesn't have to be.

Job Done.


'ope-that-'elps.





G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[kat25]

Thanks LittleSmudge!
I will give it a try.