input to textbox if the form is readonly

[Dave_D]

I've made my form readonly based upon which user opens this form. I have a textbox which I'd like to make either enabled and/or unlocked for a user to enter their search criteria. I've tried me!textbox.enabled = TRUE, as well as
me!textbox.locked=FALSE, but neither or both methods are not allowing me to key into this textbox. Is the readonly overriding the enable and lock controls? Is there a different datamode that will allow a user to key into a textbox while the entire form is locked?

Does this method work? Or instead of ctl.Value, could it be ctl.enable or ctl.lock. If yes, what datamode need to be?

For Each ctl In Me.Controls


If ctl.ControlType = me!textbox Then
If ctl.Value <> False Then
ctl.Value = False
End If
End If
Next ctl

[orange]

look at the Similar Threads at the bottom of the page (scroll down) for ideas.
There is often info to help resolve an issue.

This one may be helpful.

From another reference:

Enabled = No means it is grayed out and unavailable to click in at all.

Locked = Yes means you can't change the data but you can click in it and do a copy of the data.

Setting Enabled = NO and Locked = YES means that it is not grayed out and you can not click in the control nor can you highlight and copy.

[Missinglinq]

As I explained in Post #7 of the thread orange gave you a link to, you need to make the Form updatable, again, 'mark' the one Control you want to be usable, then loop through all Controls and Lock all those not 'marked.'

That post gives you this approach in more detail.

Linq ;0)>

[Dave_D]

What does .tag represent in this illustration? When I added this code, all of my textboxes were locked. The name of my textbox is SearchFor wich would be the only one that I don't need to be locked

Dim ctrl As Control

For Each ctrl In Me.Controls
If (TypeOf ctrl Is TextBox) Or (TypeOf ctrl Is CheckBox) Or (TypeOf ctrl Is ComboBox) Then
If ctrl.Tag <> "DoNotLock" Then
ctrl.Locked = True
End If
End If
Next

[Missinglinq]

Tag is a Property of a Control. From the post you found the above code at:

In Design View, select the Control you want to be functioning and go to Properties-Other and in the Tag Property box enter DoNotLock, just like that, no quotes.

Linq ;0)>