Trobule insert into table

[ncdata]

I have a form that is based on Scope table. Within that form there are multiple fields(text box, combo and list). I have some of the fields pre populated based on a form upon the form opening. I have looked at the form properties and I have
Data Entry = Yes
Allow Additions = Yes

When I go to make an update to any of the fields I receive a ding sound. Does each one of the fields need a after update procedure defined prior to the user being able to update the fields.

Any guidance would be appreciated as I have another form that I will be doing something similar.

 

[John Big Booty]

Welcome to the forum.

You may have misunderstood what the Data Entry property does. When set to No or False it simply means that the user can see all records as well as have the ability to add new records. When this property is set to Yes or True the user will have no access to existing records and will only see records that he has entered since he opened the form.

Do you get any warning message?

 

[missinglinq]

I have a form that is based on Scope table. Within that form there are multiple fields(text box, combo and list). I have some of the fields pre populated based on a form upon the form opening...When I go to make an update to any of the fields I receive a ding sound.

The 'ding' indicates an error and I suspect that the Fields you're attempting to update are the same Fields you mention above as being pre-populated. What, exactly, do you mean by 'based on a form upon the form opening,' and how are you pre-populating the Controls?

Linq ;0)>

 

[ncdata]

Sorry if I wasn't clear. Upon logging into my database opens to a main form. When a command button is clicked it opens a popup to select a project type from a combobox. Based on that selection there are fields filled out that are around that type of project(hours,duration and other items).

The fields I am trying to edit aren't those that are self populating. The backend to this access database is SQL server so in looking at the table permissions there is no access to write. I am thinking that is the problem and will do some digging today.

Let me know if I am missing anything or if there maybe a seperate cause.

 

[rodmc]

If you have no access to write to the tables then you really need to talk to the Server admin to change the permissions, nothing you can do on the client side can help, unless of course you can yourself access the table defs yourself