Unable to update check box on Form. (1 Viewer)

A

ANP

Registered User.

Local time

Today, 13:53

Joined

Dec 1, 2012

Messages

23

• Oct 1, 2014

• #1

Hi All,

I have a form which is based on a query which selects information from three different tables. All fields apart from one are locked, all are enabled. The table the field I wish to update is native to the current DB i.e. is not a linked table.

when I activate the form and try to click on the Check box, which is not locked, I get a beep but it does not change state.

I am using Access 2007 on win7 Pro.

I know this is not much to go on.

I look forward to your comments.

Regards

ANP.

 

spikepl

Eledittingent Beliped

Local time

Today, 22:53

Joined

Nov 3, 2010

Messages

6,142

• Oct 1, 2014

• #2

http://allenbrowne.com/ser-61.html

 

A

ANP

Registered User.

Local time

Today, 13:53

Joined

Dec 1, 2012

Messages

23

• Oct 1, 2014

• #3

Hi Spikepl,

I have checked the points in your post and I can not see any thing that applies to my query.

However I do have two fields that concatenate data as below

Name: [tblClients]![clt_TitleID] & " " & [tblClients]![clt_FirstName] & " " & [tblClients]![clt_Surname]

could this be the issue?

Regards

ANP

 

spikepl

Eledittingent Beliped

Local time

Today, 22:53

Joined

Nov 3, 2010

Messages

6,142

• Oct 1, 2014

• #4

No.

If you run your query in the query designer are you able to update data in it?

 

A

ANP

Registered User.

Local time

Today, 13:53

Joined

Dec 1, 2012

Messages

23

• Oct 1, 2014

• #5

I am unable to update the field in the datasheet view of the query.

I am able to update it in the datasheet view of the table it belongs to.

Regards

ANP

 

spikepl

Eledittingent Beliped

Local time

Today, 22:53

Joined

Nov 3, 2010

Messages

6,142

• Oct 1, 2014

• #6

I am unable to update the field in the datasheet view of the query.

Click to expand...

so your query is not updateable!