Here's a small tutorial I've given people for doing this kind of thing.
Remove whatever you've done to make the Form Read-Only, 'mark' the one Control you want to be able to use, your Combobox, so that Access can recognize it, then loop thru all Controls and Lock those not 'marked.'
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.
Then place this code in the code window:
Code:
Private Sub Form_Load()
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
End Sub
You should be set!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007