By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,574 Members | 1,201 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,574 IT Pros & Developers. It's quick & easy.

Datasheet form - cant add new record

P: n/a
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

Jun 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try to change DataEntry to No. DataEntry to yes its like you are into a
new record.

Jun 19 '06 #2

P: n/a
Unfortunately, insert record is still greyed out with data entry set to
yes or no.

Paul

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


Jun 19 '06 #3

P: n/a

pa************@hotmail.com wrote:
Unfortunately, insert record is still greyed out with data entry set to
yes or no.

Paul

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


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

Jun 19 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.