Cannot select checkbox

[acl499]

Hi All. Im new here so apologies if i've posted this in the wrong place.

Background: I have an MS Access continuous form. The form has a recordsource to my main table. Under the detail section there is a checkbox that is bound to a Yes/No field in the main table.

Problem is that when i click on the checkbox, nothing happens.

Im probably missing something obvious however some criteria:
- Allow Edits is set to yes
- Locked is set to No
- Enabled is set to Yes

The main table has a primary key to an ID that is just an Autonumber.

Any suggestions?

Final notes is searching other forums, one suggestion to similar problems is checking my recordsource is updateable. Can someone explain how to do this? - Quite new to MS Access and programming so bear with me!

Many thanks,

Alvin

 

[missinglinq]

The form has a recordsource to my main table

Are you saying that the form is based on the main table alone or on a query that includes the main table?

Final notes is searching other forums, one suggestion to similar problems is checking my recordsource is updateable. Can someone explain how to do this?

By opening the recordsource, be it a table or a query, independently of the form, and seeing if you can edit a record.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[acl499]

Thanks for the quick response and clarification.

My recordsource is a combination of the main table (tbl_Activity) and lookup tables (tbl_Process). When an entry is logged, the process has a Process ID. That ID refers to a description within tbl_Process.
My recordsource has the link as i need to display the description in the detail section of the form.

As for the updateable recordsource... i've copied the sql into a query, and whereas the table i can update a field, the query i am unable to do so. Hence the recordsource is not updateable.

Is it possible to have a query that is updateable. If so how do you create one?

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[acl499]

Thankyou to PHV and Missinglinq.

The query wasn't updateable due to the primary key of one of the lookups not being set up correctly.

Thankyou for all your help.

acl499

 

[missinglinq]

Glad we could help!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!