Insert button is gray out, why?

[wcheung]

I create a form with 2 tables. After the form is created, I can only read the data in database, but the insert button is gray out (a button w/ an arrow beside the star). Anyone know why this happnes? Please help.

 

[Gina]

I am assuming you have a query behind the form which
displays the data from both tables in the form. Check the
query, if I'm right the query is not updatable which is
why you can only VIEW data in the form. You will need to
adjust the query to be an updatable one. Once you do that
you should be able edit, add, etc.. data in the form view.

Hope that helps...

-----Original Message-----
I create a form with 2 tables. After the form is created,

I can only read the data in database, but the insert
button is gray out (a button w/ an arrow beside the star).
Anyone know why this happnes? Please help.

 

[Dirk Goldgar]

I create a form with 2 tables. After the form is created, I can only
read the data in database, but the insert button is gray out (a
button w/ an arrow beside the star). Anyone know why this happnes?
Please help.

From the sound of it, I'd guess that your form's recordsource -- as
shown on the Record Source line on the Data tab of the form's property
sheet in design view -- is not updatable. Some queries are updatable,
some are not. A query involving just two tables can probably be made
updatable, providing each table has a primary key defined for it. See
the help topic, "When can I update data from a query?". If that doesn't
help you figure it out, reply here with the SQL statement that is your
form's recordsource query, and we'll take it from there.

Oh, before doing that, make sure that your form's AllowAdditions
property (also on the Data tab of the property sheet) is set to Yes, and
that it is read-only even when you open the form directly from the
Access database window, rather than from a switchboard form of some
kind.