Enabling controls on a form

[crowegreg]

On a form used for editing records, after retrieving a record, some of the fields are set to enabled = false. After saving the record, I need to make sure all the fields on the form are set to enabled = true. I've written this code.

For Each ctl In Me.Controls
Debug.Print strGroup
If ctl.Tag = strGroup Then


Debug.Print ctl
ctl.Enabled = "True"

End If
Next ctl

When testing, it goes through the first control without any problem, when it reaches the second contol, after pressing F8 on the statement debug.print ctl, it immediately ends the function, and returns me to where the function call statement was made.

If the debug statement is not within the code, after pressing F8 on the statement ctl.Enabled = "True", it ends the function like above.

[Bob Fitz]

What is strGroup?

As you step through the loop you will need to test what kind of control it is. Some controls do not have an Enabled property.

[crowegreg]

Within each control on this form, I've put in a tag. Currently my tags are Group1, Group2, Group3. Before I run this loop, I assign the correct group to strGroup.

How do I determine the type of control?

Which controls do not have an enabled property?

[Bob Fitz]

How do I determine the type of control?

Which controls do not have an enabled property?

Take a look at "ControlType Property" in the VBA Help file.

[crowegreg]

Thanks, I'll read about controls.