How do I add a record?

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

Guest

I created a form in Access 2003. It won't allow me to create any more
records. It just tabs through Page 1 of the form and never creates a new
page/record. My Properties are set to AllowAdditions:Yes. The navigation
numbers at the bottom are mostly grayed out. Insert: New Record in the
toolbar is grayed out as well. How can I create another record?
 
Is the form based on a query or SQL statement? If so, try opening the query
directly to see if the query is read-only.

If not, is the form's AllowEdits property set to Yes?

What about the Enabled and Locked properties of the controls?
 
eslinc said:
I created a form in Access 2003. It won't allow me to create any more
records. It just tabs through Page 1 of the form and never creates a new
page/record. My Properties are set to AllowAdditions:Yes. The navigation
numbers at the bottom are mostly grayed out. Insert: New Record in the
toolbar is grayed out as well. How can I create another record?
Click to expand...

It sounds as if the data source for the form is not updatable. Have you
tried adding a record directly into the form's query?

Regards,
Keith.
www.keithwilby.com
 
Thanks for the tips. I'm fairly new to Access and unfortunately don't quite
understand what is being suggested. I just built the form using design view,
learning as I went. How do I add a record to a form query? I don't know what
that means. I thought all Ihad to do was create the form, then input
information when it was completed. The form seems to work great accept that
it won't create a new record when I reach the end. Settings are: AllowEdits
-Yes; Enabled -Yes; Locked -No. Thanks.
 
eslinc said:
Thanks for the tips. I'm fairly new to Access and unfortunately don't
quite understand what is being suggested. I just built the form using
design view, learning as I went. How do I add a record to a form
query? I don't know what that means. I thought all Ihad to do was
create the form, then input information when it was completed. The
form seems to work great accept that it won't create a new record
when I reach the end. Settings are: AllowEdits -Yes; Enabled -Yes;
Locked -No. Thanks.
Click to expand...

You did build a table or tables first though right? Forms only save data when
they are bound to tables. In some cases queries based on the tables are used
and forms bound to those, but not all queries allow updating the data. If you
are using such a query that would explain why you couldn't make changes.
 
Well ... in the form, all of my fields, all of the boxes where I would enter
data, read "unbound." They are each linked to the description properly,
though. For example, I have an entry for City, and a blank box beside it, and
those two items are linked properly, but the box says "unbound." If I go to
Datasheet View, all of my form's descriptions are there in one long line. If
I look in the Database window and click on Forms, I see the name of the form
I created, however there are no new files listed under any of the other
options such as Tables, Queries, etc.
 
eslinc said:
Well ... in the form, all of my fields, all of the boxes where I
would enter data, read "unbound." They are each linked to the
description properly, though. For example, I have an entry for City,
and a blank box beside it, and those two items are linked properly,
but the box says "unbound." If I go to Datasheet View, all of my
form's descriptions are there in one long line. If I look in the
Database window and click on Forms, I see the name of the form I
created, however there are no new files listed under any of the other
options such as Tables, Queries, etc.

"Rick Brandt" wrote:
Click to expand...

I would then suggest starting with the help file at page one. Creating an
Access app begins with setting up tables. Forms come later and are used as a
means to enter data into the tables. Forms (by themselves) are fairly useless.
 
So, there's no way to create a table using the form, which means I should
just delete the form and start over with a table.
 
So, there's no way to create a table using the form, which means I should
just delete the form and start over with a table.
Click to expand...

Well, that's not obligatory. You can create a Table, and then set the
Form's Recordsource to the table, and each control's Control Source to
its corresponding fieldname. It's probably a tossup which is easier.

But: data is stored in Tables, and only in Tables. Forms are just
windows, tools to let you enter and edit data into Tables. Building a
database with Forms and no Tables is a bit like building a house with
windows and no frame!

John W. Vinson[MVP]
 
That's some good news. I'll follow the suggestion and try creating a table,
then matching it up with the form. Thanks for the specifics about how to do
it, and thanks all for the guidance.
 
Back
Top