Data Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have tried to created a data access forms based on a simple table but we
are not able to add any records. we have not being able to find why

I would appreciated any comments regarding this issue

Thanks
 
I tried, i took a look at the Gropu Properties of the form and the allow
Addtitions and allow delete are set to true, still it does not allow me to
enter any records, is like The page does not support data entry, i have
another form from another database and i was able to get it to work but i am
not sure what it was done, i have checked almost every property.

any other suggestions?
 
The only other thing I can think of is if there is any VBA code behind the
form, it might set the form property Allow Additions in there.
 
it does not make sense that this happening, i have created another form from
scratch, (created the table, then created the form in design view added a
text box then linked to one of the records) and still does not allow me to
add edit any records. weird. i know there is got to be one setting but i can
not find it.
 
Got It! the issue was that the table did not have a primary key.

once i set up a key i am good to go, i am able to add, delete, modify
records....
 
Back
Top