Unwanted Filter ?/

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top