Unwanted Filter ?/

D

Dave

Thankyou for the past advice, however I have searched and searched for any
filter code or crook data.

When I open the main form called either from a switchboard form or clicked
on directly, the main form opens with no data showing except for data in
cbo's, the form is blank of any active data.

The record selector is at the blank position with only AutoNumber showing.
When I click on Remove Filter/Sort, then form populates with rec #1. Also a
Err Msg drops and displays : "The value you entered isn't valid for this
field etc, etc".
I then click on the OK and all appears totally normal.
I have searched the switchboard Form, there is an option to use a filter:
-'Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' ", which I
blocked out.

But it matters not if I use the SW/b or click direct on the main frm, still
what appears as a filter is blocking any data from view.

Need I say, I am stumped ?
Dave
 
V

Van T. Dinh

The Filter on the Switchboard Form has nothing to do with this.

Check the "Data Entry" Property of the Form. You find this Property in the
"Data" tab of the Properties window of the Form. It sounds like this
Property has been set to Yes / True but you want No / False.
 
Top