how to search on a disabled/locked control (97)

[arage]

I have a form & used a wizard to install a search feature for it. A very important control on the form would most likely be the first criteria searched but I

[TexasTJ]

Try using the OnFilter event for the form to unlock/enable the control. It would be a few simple lines of code something like:

txtSSN.Enabled = True
txtSSN.Locked = False

Then use the OnApplyFilter event to reset the lock.

txtSSN.Enabled = False
txtSSN.Locked = True

[arage]

I did the following code in the click event of my search button, let me know if this is ok as it is essentially giving me the result I want.

Me.txtReferenceNumber.Enabled = True
Me.txtReferenceNumber.Locked = False

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Me.txtReferenceNumber.Enabled = False
Me.txtReferenceNumber.Locked = True