Data Entry, “yes.” doesn't all allow data entry

[hilian]

I want to have a form that opens to allow users to add new records. I set the data properties to Allow Edits, “yes”, Allow Deletions, “yes” Allow Additions, “yes”, and Data Entry, “yes.” When I open the form, it opens to the first record, not a new record, as I intended, and when I use the arrow to get to the last record, the add records icon is grayed out, and I still can’t add.

What do I do next?

 

[gemma-the-husky]

what is your form bound to - the table, or a query

the data entry is the key - setting this to yes, only allows you to enter new records - but all the new records you add in a session can be edited or deleted - so maybe you are seeing the records in the current editing session

the grayed out new record area suggests something is not quite right though - so check that data entry is indeed set to yes, and check the data source of the form

 

[hilian]

Thanks, gemma,
The form is bound to a table. I'm just setting it up, so I'm only experimenting with adding new records, although, so far, I wasn't able to enter anything. I was able to see all of the records in the table I used. I did check several times that Data Entry was set to "yes." There was nothing changing it back to "no" after I saved it. I kept rechecking. Just as a test, I set up a new data base with a new form bound to a copy of the same table, I set Data Entry to "no" to see what would happen. Access allowed me to add new records.

What am I missing?

 

[hilian]

No. It's a main form. What I seem to have discovered by trying it is that selecting "yes" results in the "add new records" button being greyed out, and selecting "no' results in the button being active, and I can add records. It doesn't make sense, but it seems to work that way. I'm using Access 2003.

 

[hilian]

HI Pat,

I tried creating a new form in a new database. I set the property to "yes" and I still wasn't able to enter data. Then I tried setting it to "no". That didn't work either, although it does in the first data base. There's either a setting which I'm not finding, or my copy of Access has something wrong with it.

As long as I can enter data in the original data base with "no" meaning "yes" (and "yes" meaning "no"). I'll live with it. No?

Thanks,

Henry

 

[hilian]

Hi Pat,

I had to create a sanitized version of the database, which I've attached. I created a simplified form with only a few of the fields I want to have on it. When the Data Entry property is set to "yes," none of the records show, and the record counter shows 1. When it is set to "no," all of the records are available, and I can get to the end of the file and enter new records.

Thanks,

Henry

 

[hilian]

Thanks. That clarifies it. Now I have to decide if I want toe user to see all of the records or only the new ones. Probably just the new ones. I suppose I can set up another form to use if there's a need to go back and modify a record that's already in the system.

 

[hilian]

Thanks, Pat. That's a great idea. That's how I'll set it up.

 

[Robison]

I have a similar situation....I have a query that has several tables associated with it. It basically is a monthly form of sales. CurrentMonthOrders I want to be able to enter a date that the apparel is ordered and when the order is complete to be able to check the order complete. Most of the data will be coming in to the form/report but I want two of the field to be interactive. Right now it is not working. I can fill in the tblOrder but my query does not have a 'new' indicator (which I don't understand) and the form will not allow input. Can you help. Thanks in advance for any assistance. (I have attached my database for your viewing. Sharon
I did change it from a report to a form as I didn't think I could interact with a report.

Again I sure appreciate any assistance I can get.

 

[meenctg]

Hopefully this link will help you http://learn24bd.com/open_form_with_data_entry_mode/