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

Is the form based on an updateable recordset?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"AlphaFox" <(E-Mail Removed)> wrote in message
news:E5A4E322-6BC6-48F2-99C8-(E-Mail Removed)...
> 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

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

"Jeff Boyce" wrote:

> Is the form based on an updateable recordset?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "AlphaFox" <(E-Mail Removed)> wrote in message
> news:E5A4E322-6BC6-48F2-99C8-(E-Mail Removed)...
> > 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
>
>
>

On Thu, 19 Jul 2007 09:10:02 -0700, AlphaFox
<(E-Mail Removed)> wrote:

>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]

AlphaFox wrote:
> 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).

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

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" wrote:

> On Thu, 19 Jul 2007 09:10:02 -0700, AlphaFox
> <(E-Mail Removed)> wrote:
>
> >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]
>

On Tue, 24 Jul 2007 08:32:01 -0700, sturner333
<(E-Mail Removed)> wrote:

>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]