Access form not accepting values.

[usr123]

I really need to get this working. I dont want to update any record at the moment, just want to enter new record. Can anyone guide me in the right direction.Thanks!!

 

[missinglinq]

If i want to update an existing record then only i need an ID/Primary key in the table,but if i want to just enter the records then it shouldn't need any ID/Primary key. At the moment i only need to enter new records in the data and for that i dont need any updatable query.

Where did you ever get that idea? Your record source must be capable of being updated in order to add records as well as to edit records. And with a SQL back end you have to have a Indexed/Primary Key.

 

[usr123]

I didnt add any ID in my table, and added the new record through code and its working fine.Thanks for help!!

 

[boblarson]

I didnt add any ID in my table, and added the new record through code and its working fine.Thanks for help!!

With no ID field in your table, I think you are setting yourself up for a major set of problems down the line when you want to actually do something with the data. Each record should have a unique identifier available to it so that it can be identified and returned by the program. I fear you are just not seeing the forest for the trees (seeing an isolated spot and not seeing the big picture).

Good luck, because you'll need it (or others will when they try to use the data).

 

[usr123]

Thanks for your reply, you are right that in the future,if i need to update any existing data, then i will need a primary key in the table.I understand that,but requirement was not to change it, just enter new data in the table.