Can't Add New Record to Form!

[Guest]

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

 

[Jeff Boyce]

Is the form based on an updateable recordset?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

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."

 

[John W. Vinson]

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]

 

[Rick Brandt]

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).

 

[Guest]

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.

 

[John W. Vinson]

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.

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]