problems adding data to a database using a form

  • Thread starter Thread starter R.H.
  • Start date Start date
R

R.H.

I have a database with about 28 different enties and three sub tables.
I created 4 forms; one for each table. I can change and delete data in
the sub forms, but not in the main forms although it seems like I used
to be able to. I am using MS Access 2003. Does anyone know what I am
doing wrong; I am quite new to access databases.

Roger
 
I have a database with about 28 different enties and three sub tables.
I created 4 forms; one for each table. I can change and delete data in
the sub forms, but not in the main forms although it seems like I used
to be able to. I am using MS Access 2003. Does anyone know what I am
doing wrong; I am quite new to access databases.

Roger
Click to expand...

You'll need to give us a bit more help here.

You say main *forms*. Multiple forms? Why?

What is the Recordsource property of the form which isn't letting you
add data?

Have you inadvertantly set the Allow Edits property of the form to No?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John said:
You'll need to give us a bit more help here.

You say main *forms*. Multiple forms? Why?

What is the Recordsource property of the form which isn't letting you
add data?

Have you inadvertantly set the Allow Edits property of the form to No?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...


Actually, everything is done in access. The application is an access
developed application. I am not using any external language such as
Visual Basic or C++. The database and its forms, queries, reports is
done completely from within Access. As for multiple forms, why not?
I have a main switchboard form which brings up a switchboard for
reports, forms, and queries. You just click on a button for whichever
query, report, or form that is wanted.

Roger
 
Actually, everything is done in access. The application is an access
developed application. I am not using any external language such as
Visual Basic or C++. The database and its forms, queries, reports is
done completely from within Access.
Click to expand...

Ummm... I didn't mention anything about other languages.

If you open your Forms in design view, and view their Properties, one
of the properties is "Allow Edits". If that is set to No then you will
not be able to edit data on the form.

Another property is the "recordsource" property. This is the Query or
table containing the data shown on the form. If the Recordsource is
not an updateable query, you won't be able to edit on the Form.

It sounded like you had multiple main forms for editing the same
table; my apologies for misconstruing your post.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top