Make the Add New Navigation key come back?

[Np02]

Hello,

I have a form that I want to add new record, but I find that in the Navigation bar, the Add New button is grey out, (The Previous and Next buttons still work). I checked the Form DATA property, Allow Addition is checked "Yes". The Control Source of DATA of the Form is written as "SELECT tbl_1.Name FROM tbl_1". Did I do anything wrong to make the ADD New navigation button greyed out? How do I make it come back to allow adding new record?

Thank you for advice.

Np

 

[PaulBricker]

Np, there doesn't seem to be anything wrong from your description. You can't see the add new button because the table is not updatable (or you missed one of the properties that allows you to add records but your indication is that these are set appropriately). Are there other fields in your table besides Name. What, if any is the primary key for the table. Provide us with as much info as you can and maybe someone will see something.

Paul

 

[Np02]

Paul:
Thanks. I just find out it is primary key issue. I put one of the field on primary key. The new button appears. Thank you anyway.

NP