Filtering a form with "Allow Edits=false"

[atkellyx]

Hi

I am on Access 2003 on XP.

When I set a form to allow edits = false, combo boxes on that form that are not data bound become locked also. I used these for filtering purposes,ie, users can filter the form on a combo click.

Is there any way to leave these enabled when allow edits = false?

Thanks

AKC

[puppydogbuddy]

Hi

I am on Access 2003 on XP.

When I set a form to allow edits = false, combo boxes on that form that are not data bound become locked also. I used these for filtering purposes,ie, users can filter the form on a combo click.

Is there any way to leave these enabled when allow edits = false?

Thanks

AKC

Try placing this code behind your form:

Private Sub YourCombo_GotFocus()
Me.YourCombo.Enabled = True
Me.YourCombo.Locked = False
End Sub

[atkellyx]

Try placing this code behind your form:

Private Sub YourCombo_GotFocus()
Me.YourCombo.Enabled = True
Me.YourCombo.Locked = False
End Sub

Thanks but that was the 1st thing I tried and has no affect whatsoever.

I am thinking the allowEdits is applied at the form level and overrides all form (data type) controls.

Even moving said combo into header/footer doesn't work.

Buttons work, and I could open a filter form but this is a pain. I would have to retrofit this fix to a large number of forms.

Ooooh, the pain, it's all too much, think I'll get a job picking coconuts instead.

Thanks

AKC

[missinglinq]

I think the problem with puppydogbuddy's code is not the code, but where it's placed! You can't change a property of an object such as Locked or Enabled when that object has the focus! Try it in the Form Load event instead!

Linq ;0)>

[puppydogbuddy]

I think the problem with puppydogbuddy's code is not the code, but where it's placed! You can't change a property of an object such as Locked or Enabled when that object has the focus! Try it in the Form Load event instead!

Linq ;0)>

Linq,
Good catch! You are absolutely correct. I was not thinking.......

[atkellyx]

Linq,
Good catch! You are absolutely correct. I was not thinking.......

Thanks but that's where I tried it. It still doesn't work.

Cheers

AKC

[puppydogbuddy]

Thanks but that's where I tried it. It still doesn't work.

Cheers

AKC

Ok, then why can't you just set the allow edits property to true whenever the combobox gets focus, and set it to false when it loses focus.