Need to lock a group of combo boxes

C

CSDunn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box 0
Combo or list box 0
synchronized Combo Boxes in subforms 2
First Subform record gets modified when closing form 3
Split form 0
Macro doesn't work first time form is opened. 2
Combo box to search on a field in the subform 1
Several combo boxes (with "All" option included) in a form/subform 4

Top