Can't Add New Record to Form!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AlphaFox - 19 Jul 2007 17:10 GMT

I'm trying to add a new record to a form. The navigation buttons at the
bottom don't have the new record (>*) highlighted and avaliable for use. I
have tried both Data Entry Yes/No. Thanks

Reply to this Message

Jeff Boyce - 19 Jul 2007 17:57 GMT

Is the form based on an updateable recordset?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> I'm trying to add a new record to a form. The navigation buttons at the
> bottom don't have the new record (>*) highlighted and avaliable for use. I
> have tried both Data Entry Yes/No. Thanks

Reply to this Message

AlphaFox - 19 Jul 2007 18:14 GMT

The form is based on 4 seperate tables with updateable data. A error message
suggests, "Can't go to specified recordset. You may be at the end of a
recordset."

> Is the form based on an updateable recordset?
>
[quoted text clipped - 6 lines]
> > bottom don't have the new record (>*) highlighted and avaliable for use. I
> > have tried both Data Entry Yes/No. Thanks

Reply to this Message

Rick Brandt - 20 Jul 2007 00:26 GMT

> The form is based on 4 seperate tables with updateable data. A error
> message suggests, "Can't go to specified recordset. You may be at the
> end of a recordset."

You can't base a form on four separate tables. If you chose four tables while
using the wizard to build your form then Access built for you a query based on
the four tables and your form is bound to that query.

Multi-table queries are often not editable and the more tables you add the
higher the chances are that the query will be read only. With four tables it is
almost guaranteed.

The proper way to use forms for multiple tables is to use subforms with the main
form and each subform bound to exactly one table (or a query based on one
table).

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

John W. Vinson - 19 Jul 2007 18:56 GMT

>I'm trying to add a new record to a form. The navigation buttons at the
>bottom don't have the new record (>*) highlighted and avaliable for use. I
>have tried both Data Entry Yes/No. Thanks

Data Entry is a bit misleading: it lets you enter new records but not view or
edit existing ones. Check the form's Allow Edits and Allow Additions
properties (both should be true). More likely, though, is that the form is
based on a Query which is not updateable. What's the form's Recordsource
property? If it's a query, is it updateable? Open it in datasheet view and see
if it has a "new record" line. If it's not, post the SQL view of the query
here and we'll see if we can't get it working for you.

John W. Vinson [MVP]

Reply to this Message

sturner333 - 24 Jul 2007 16:32 GMT

I am having the same problem. I don't know what happened but this morning
whenI opened up the form I am working with, it didn't allow for new records
and would not let me update the displayed records. I am supplying data to the
form via a query with this SQL:

SELECT divisionBOM.partCost, divisionBOM.Quantity, divisionBOM.id,
divisionBOM.division, divisionBOM.PN, divisionBOM.newBusiness,
divisionBOM.percNewBusiness, divisionBOM.description, [partcost]*[quantity]
AS lineTotal, ([partcost]*[quantity])*([percnewbusiness]/100) AS lineTotal2
FROM divisionBOM
GROUP BY divisionBOM.partCost, divisionBOM.Quantity, divisionBOM.id,
divisionBOM.division, divisionBOM.PN, divisionBOM.newBusiness,
divisionBOM.percNewBusiness, divisionBOM.description;

any help would be greatly appreciated.

> >I'm trying to add a new record to a form. The navigation buttons at the
> >bottom don't have the new record (>*) highlighted and avaliable for use. I
[quoted text clipped - 9 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 24 Jul 2007 17:03 GMT

>I am having the same problem. I don't know what happened but this morning
>whenI opened up the form I am working with, it didn't allow for new records
[quoted text clipped - 11 lines]
>
>any help would be greatly appreciated.

The query has changed, then. No GROUP BY query is ever updateable (and, of
course, no calculated field such as Total is ever updateable).

Since you're not using any SUM or COUNT or other aggregate functions, open the
query in design mode and unselect the Greek Sigma icon (or, equivalently, open
it in SQL view and remove everything from GROUP BY to the end).

John W. Vinson [MVP]

Reply to this Message