By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Repeat Post: Need to lock a group of combo boxes

P: n/a
Hello,
In an Access 2000 ADP subform, I have a set of two Radio buttons in a single
group that are bound to a field called 'Completed'. The Completed field
comes from an SQL Server 2000 table, is of type Bit (so it takes 0 or 1).

I need to set up a procedure so that when the radio button has a value of 1,
a series of combo boxes in the Detail section of the subform have the Locked
property set to Yes. If the value is zero, the Locked property of the combo
boxes needs to be set to No.

I have several subforms, and they all have different numbers of combo boxes
in them, so I need for the one procedure to work with any of the combo boxes
in any subform.

I have a procedure I am trying to modify that addresses all text boxes on a
form, but I am not sure how to address just the Detal section of the form.

Any ideas?

Thank you for your help!

CSDunn
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I am not sure from you question what your problem is. Is it that you want
to write code that blindy does something to every control in the detail
section of a form, but not to controls in other sections of the form?
"CSDunn" <cd***@valverde.edu> wrote in message
news:80**************************@posting.google.c om...
Hello,
In an Access 2000 ADP subform, I have a set of two Radio buttons in a single group that are bound to a field called 'Completed'. The Completed field
comes from an SQL Server 2000 table, is of type Bit (so it takes 0 or 1).

I need to set up a procedure so that when the radio button has a value of 1, a series of combo boxes in the Detail section of the subform have the Locked property set to Yes. If the value is zero, the Locked property of the combo boxes needs to be set to No.

I have several subforms, and they all have different numbers of combo boxes in them, so I need for the one procedure to work with any of the combo boxes in any subform.

I have a procedure I am trying to modify that addresses all text boxes on a form, but I am not sure how to address just the Detal section of the form.

Any ideas?

Thank you for your help!

CSDunn

Nov 12 '05 #2

P: n/a

Actually, I wanted to just address combo boxes in the detail section of
the form.

I have received some code samples on how to do this, and I will post
again if I still have trouble with it.

Thank you for asking!

CSDunn
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.