Access 2003 database - adding a field?

[Stu-art]

Hi

I'm adding to a database that someone else set up. I went to the Design View page and clicked on one of the buttons at the bottom to add a text box etc etc. It all looks fine, but the field doesn't seem to be active - if I add some text into it for one page of the databse, the same text appears on every page of the databse. I notice that my "new field" is not listed in the fields list. How do I add it? I keep looking through "The Missing Manual" but without spending 3 days reading the whole thing (which I don't have time for) and learning much much more than I need to know just to get to the part that I need to know, it isn't helping me much.

Please can anyone enlighten me? My email is stu_paranormal@yahoo.co.uk

Thanks!

Stu

 

[djshrew]

stu, it do you have the ability to up the database. so someone else can have a peek at your problem.

Plus im sure you did't mean to but you doubble posted this mate.

 

[neileg]

You need to add the field to the underlying table, not just to the form. If the form is based on a query (which it should be) you have to add the field to the query as well by dragging it from the table in query design view. Then go to your form and pick the new field from the field list and drag it onto the form.