new to access

[roh_8_it_3]

hi all,

i m new to access.I need a help.i m binding a form directly to the table.I also want to insert data through this form.

but the problem is suppose if i dont have any data .then it doesnt display me anything and so i cant enter the records.

is there any way so that i can enter data.i have checked the allow additions property its set to yes.

thanks a lot for any help

 

[krunalprajapati]

there is a property of a form called "Allow Additions".

so select ur form and in property window set this property to yes.

also form has "Allow Deletions" and "Allow Edits" property. make this also yes to edit or delete records from ur form.

 

[roh_8_it_3]

thanks a lot .actually i checked these properties but they were set to yes.i had other problem .the table to which i had bound the form didnt have a primary key thats why it was not showing any controls.

I didnt know abt this thing

thanks

 

[adevera]

does your form does not alow you to add new data? if all form property are set to yes, it will allow you to ad new record. maybe you haven't set the control source of each field on the form to a respective field on the table or you dont have a record source value on the form.

checked the form property if you have anything in the record source.

 

[krunalprajapati]

if all properties r set to yes then try adding data in table directly and see if they r displayed in the form or not. If they r not displayed than u didn't set the recordsource property of the form to the table.

OR if u have written a query in the recordsource property than check the query for the data.