Not able to append.

[PaulSharma]

I have a table which is connected to a form. I am able to see records in the form fields but i am not able to add anything in that table using form fields.

 

[Liv Manto]

Check the properties - Data Entry, should be yes

 

[PaulSharma]

Yes, Data Entry = Yes , it is only show records there in my database but not allowing me to enter new record

 

[neileg]

Is the form based directly on the table or is it based on a query? Usually, the advice is to always use a query, but some queries that use aggregate functions and for other reasons, lead to a 'not updateable' record set.

 

[Liv Manto]

Yes Paul, it occured to me that it was based on a query but you did say it was based on a table.

So check your recordset, open it as a query dataset, if the navigation button below hides the new record, then your query is not updateable.

you can take out the appended table and just create a lookup field in your main table. Check the northwind database , form "Products".

It is based on one table, yet the Control - Category, get its row source data from a query.

Check the properties of the control- Category Id, see how it gets its data.