Unable to add records to my table

[santhosh23]

Hi ..I was updating my records by filling a form and entering the data's into a table but all of a sudden i couldn't add data to form and table..can anyone please help on this issue....thanks in advance

 

[spikepl]

When asking for help you need to be specific and describe the symptoms, not interpret, because that is ambiguous. Se my signature and state your case again

 

[santhosh23]

Hi ..I am created a subform in my navigation page and created a list of fields in that ..which gets input and updates to a table..everything was working fine and I added around 50 entries to my form which is written to table ..but all of a sudden i couldnt add datas to my subform and table..I afraid i clicked some buttons..but I couldnt figure it out..any help

 

[spikepl]

what is "I could not add data" ? Your arm got stiff? Yu cannot reach keyboard? what do you do and what is the response. Not to be bitchy, but do not interpret but say what happens, what does the system do/say? We cannot see the screen.

 

[santhosh23]

I am able to fill the fields in the form but when i click save ..it doesnt save in my subform and in the table..system doesnt throws any error..but no data is added ..hope i made that clear.

 

[spikepl]

You probalby set AllowEdits to falseor Allow Additions to false. Under the properties of th esubform (and also the form) check the Data tab. Those properties are there. Put cursor in the field where value is, and press F1 to get help on it.

 

[santhosh23]

I checked those property before posting in this forum..they are fine..I am wondering is this anything related to record source or record locks..???

 

[spikepl]

Did you chnage record source? IF teh record sourfce is not updatebale it normally says so in teh lower left-hand corner of the screen. That's why I wanted specifics.

Open the record source and try to change somethinbg there.

Ifyour recordsource is nOot updatebale the reaSons can be here. http://allenbrowne.com/ser-61.html

 

[spikepl]

Have to go now. If you can't make it work then use your backup. If you don't have a backup then you have a problem (and I guess you will have backups in the future - I take backup for each major change and also for each bunch of smaller changes).

 

[santhosh23]

Hey I changed all the settings as before and it worked..Thanks a lot for helping and the information you provided..