Can't Add New Record to Form!

[AlphaFox]

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

 

[AlphaFox]

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]

 

[sturner333]

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]