form opens locked up - filter issue?

[johnqzsmith]

Help! What seems like a simple problem is driving me crazy.
I have a form (one of 2 that are nearly identical) that appears to be opened “filtered”.

When the form opens, none of the controls react to clicks, it does not allow edits. It has a feel as if a master lock is on the form. Finally, a right click to a shortcut menu saw some progress. If I select “Filter By Form” (the current record fields become blank) and then select “Apply Filter/Sort”, the form becomes “normal”, i.e. all fields and controls behave normally.

I have gone over the code of this form and its near-twin and cannot see any differences relating to this problem.

Assuming there is some type of stealth filter at play, Access Help yielded:
Use this

procedure to delete any type of filter, regardless of what method you used to create it.
1. Click in the form, subform, datasheet, or subdatasheet whose filter you want to delete.
2. Switch to the Advanced Filter/Sort window (Advanced Filter/Sort window: A window in which you can create a filter from scratch. You enter criteria expressions in the filter design grid to restrict the records in the open form or datasheet to a subset of records that meet the criteria.).
3. On the Edit menu, click Clear Grid.
4. Click Apply Filter on the toolbar.​

I can not find the “Advanced Filter/Sort” window they talk about. I am assuming that this is a filter issue.

Does anyone have any insight on why this form opens “locked” and what the related filter issue may be?

I have also tried the VBA code:
Me.Filter = ""
Me.FilterOn = False
To no avail.

Any help is certainly appreciated.
Thanks,

JQ

 

[Len Boorman]

Is the form opening from an Autoexec macro, Check the macro commands
Check the properties of the form
Is there an Event procedure against the On Open, On Load properties
Check the Properties of the controls on the form
If form is opened via a command button check the Event procedure

Len