Can not insert new record

[wizof103]

When I try to insert a new record on a form, I get the following
error. " You can't go to the specified record". The iInsert/New Record
command is not available. Any ideas. Thanks in a dvance

[WindAndWaves]

"wizof103" <wi******@bellatlantic.net> wrote in message
news:66*************************@posting.google.co m...

When I try to insert a new record on a form, I get the following
error. " You can't go to the specified record". The iInsert/New Record
command is not available. Any ideas. Thanks in a dvance

there could be a ton of reasons.

The first thing I would do is to open the underlying recordsource for the
form (is it a query or a table) and try to add a record in it. If this
works then I would go to the form settings and see what the properties are
like under the data tab.

Try that and let us know how you get on.

- Nicolaas

[Daven Thrice]

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:5F******************@news.xtra.co.nz...

"wizof103" <wi******@bellatlantic.net> wrote in message
news:66*************************@posting.google.co m...

When I try to insert a new record on a form, I get the following
error. " You can't go to the specified record". The iInsert/New Record
command is not available. Any ideas. Thanks in a dvance

there could be a ton of reasons.

The first thing I would do is to open the underlying recordsource for the
form (is it a query or a table) and try to add a record in it. If this
works then I would go to the form settings and see what the properties are
like under the data tab.

Try that and let us know how you get on.

Another issue could be not having permission to write to the database. That
could be in the database security settings or the server. If the above
doesn't pan out, check to see if you have permissions to write to the folder
within which the database resides. -- Daven

[Salad]

wizof103 wrote:

When I try to insert a new record on a form, I get the following
error. " You can't go to the specified record". The iInsert/New Record
command is not available. Any ideas. Thanks in a dvance

Do you have any code in the BeforeUpdate event that would affect
something? Are you inserting a record in the AfterUpdate event? Is it
possible you have a sequence problem where you are attempting to do
something either before or after the event you really need to do the
insert in?

[wizof103]

"WindAndWaves" <ac****@ngaru.com> wrote in message news:<5F******************@news.xtra.co.nz>...

"wizof103" <wi******@bellatlantic.net> wrote in message
news:66*************************@posting.google.co m...

When I try to insert a new record on a form, I get the following
error. " You can't go to the specified record". The iInsert/New Record
command is not available. Any ideas. Thanks in a dvance

there could be a ton of reasons.

The first thing I would do is to open the underlying recordsource for the
form (is it a query or a table) and try to add a record in it. If this
works then I would go to the form settings and see what the properties are
like under the data tab.

Try that and let us know how you get on.

- Nicolaas

Ok I have a table called Coaches, and one called Schools. Coaches
table has Fname, Lname, School, Sport, and E mail address fields.
Schools had the school name, and address in seperet fields. The tables
are related by the school field. In the query I use the Fname, Lname,
and sport from the Coaches table, and everything in the School table.
The form data comes from this query. The criteria for the query is the
sport in the coaches field. I added a new record to the coaches table
and gave is the same sport as the others. It allows a new record in
the table and the query but not on the form. Any ideas.