Datasheet form - cant add new record

[paulquinlan100@hotmail.com]

Hi

Apologies for it is im sure a very basic question...

Ive created a fairly standard datasheet form based on a query, however,
whenever i open the form there doesnt seem to be a way of adding any
new rows to it. It does contain an autonumber field, although this
doesnt display as it does in the table (with a blank row and
[Autonumber] in the ID field).

Both the 'Insert... New Record' menu option and the Add New Record
button at the bottom of the sheet are greyed out.

The Allow Edits/Deletions/additions and Data Entry properties have all
been set to yes.

Thanks for any help you can give with this problem.

Paul

[Svetlana]

Re: Datasheet form - cant add new record

Try to change DataEntry to No. DataEntry to yes its like you are into a
new record.

[paulquinlan100@hotmail.com]

Re: Datasheet form - cant add new record

Unfortunately, insert record is still greyed out with data entry set to
yes or no.

Paul

Svetlana wrote:[color=blue]
> Try to change DataEntry to No. DataEntry to yes its like you are into a
> new record.[/color]

[Cilla]

Re: Datasheet form - cant add new record


paulquinlan100@ hotmail.com wrote:[color=blue]
> Unfortunately, insert record is still greyed out with data entry set to
> yes or no.
>
> Paul
>
> Svetlana wrote:[color=green]
> > Try to change DataEntry to No. DataEntry to yes its like you are into a
> > new record.[/color][/color]

"Ive created a fairly standard datasheet form based on a query,
however,
whenever i open the form there doesnt seem to be a way of adding any
new rows to it. It does contain an autonumber field, although this
doesnt display as it does in the table (with a blank row and
[Autonumber] in the ID field). "

Many things can cause this. First Q. When you open the datasheet does
it have any records?

If it does then how many tables does the query have and are they
related in the relationship table?

Did you do any grouping on the Query?

If the tables are not related except in the query this can cause the
datasheet not to allow edits or new records. If the query has been
grouped this will also stop the ability to add newe records or edits.