Can't check/uncheck check box field on subform.

[rc51wv]

I have a sub form with a field that's a check box. When the sub form is
opened by itself, the check box works fine. When I open the form and the
subform is opened within that, the check box won't check or uncheck when
clicked on.

All the allow edits, deletions, etc... on the form properties are set to
yest, but it still doesn't work. Any idea on what I'm doing wrong?

 

[Gina Whipp]

rc51wv,

The subform will inherit the Properties of the Main form, what is the Allow
Edits, Allow Deletions, etc... set to on the Main form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[rc51wv]

yes

rc51wv,

The subform will inherit the Properties of the Main form, what is the Allow
Edits, Allow Deletions, etc... set to on the Main form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

How are the main form and subform linked? And can you edit any other field
on the subform?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[rc51wv]

Linked? Via a recordsource in the main code I guess. I'm not sure if that's
what you mean.

All the other fields on the subform are set to "enabled = no" in the
properties, so they can't be edited regardless of whether it's just the sub
form open or the main form with the subform.

 

[Gina Whipp]

You say you have a Main form with a subform attached. Are they Link Child
Field to Link Master Field or do you just have it placed on the Main Form.
If these two forms are not linked, what is the purpose of the Main Form as
it relates to the subform?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[rc51wv]

It's just placed on the main form and is in data sheet view. It's for
property verification. The user opens the MDB and it goes to the main form
which displays the property assigned to the user currently logged into the
machine via a SELECT statement.

The only field that needs to be changed is the check box for the user to
verify if the property listed as assigned to them is indeed in their
posession.

 

[Gina Whipp]

Check the subform CONTROL to see if Enabled = Yes and Locked = No...

1. Go to the Main form in Design View
2. Click on the subform
3. Look at the Properties and confirm Enabled = Yes and Locked = No

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm