form binding

[spinkung]

hi all,

i have a form which i've been working with which is/was bound to my customer table. for some reason when i now open the form there are no records and i can't add any new ones.

if i create a new form a bind the cust table then it works fine.

has anyone got any ideas why it's suddenly stopped being bound or letting me add/change anything? i REALLY don't want to have to redesign the form.

Thanks.

 

[spinkung]

ok i had data entry set to yes which was why the records weren't showing (doh!!)

but i still can't add/edit the records even though the form is bound directly to he table. allow edit/add's/filter/delete are all set to yes??


Thanks.

 

[vbaInet]

What is the Recordset Type property of the form set to?

What is the value of the Record Source property of the form? Is it a query or a table?

 

[spinkung]

hi

the recordset type is dynaset

the recordsource is directly to the customer table

??

 

[vbaInet]

Check the Locked and Enabled properties of all controls. Locked should be No and Enabled should be Yes.

 

[missinglinq]

Did you change DataEntry to Yes? If not, then someone obviously did! As vbaInet has suggested, they may have changed other things, as well! Do others have access to Design View?

Of course, it's possible that the Access Gnomes got bored and have been playing their favorite pasttime game Corruption!

I take it that you've been a 'bad boy,' have ignored the First Rule of Programming, and have no backup file. A tough lesson to learn, but most do after one experience such as this.

If it is corruption, you may be able to effect a cure by importing everything into a new, blank file. This is easy enough to do, and amazingly, frequently works!

Good luck!

Linq ;0)>