PC Review


Reply
Thread Tools Rate Thread

Ac2003 form Filter problem cannot find filter to remove it for goo

 
 
BillD
Guest
Posts: n/a
 
      14th Aug 2008
I have a form with a tab control that has 4 tabs. The main form (#1) is my
contacts form. I open this form using a switchboard.
When I open the form using the switchboard none of the command buttons
function and the first record of the table fails to appear in the form. When
I go to the tool bar and click on Records and then Remove filter the 1st
record in the table appears and all of the command buttons work.
If I open the form from the Data Base Window the form opens and the first
record appears and all the command buttons work fine.

I checked the properties of the switchboard and found the following code in
the Filter line: [ItemNumber] = 0 AND [Argument] = 'Default'. Also the filter
on load is Yes and allow filters is yes.
I changed filter on load to No and Allow filter to No and I still had the
same problem when I open the form using the switchboard. I then went in and
deleted the filter code and still had the same problem.

I checked the forms for filter codes with the following results:'
fmcontacts - no filter code/ filter on load No/ allow filters Yes
fmregistration - no filter code/ filter on load No/ allow filters Yes
fmregpayment - no filter code/ filter on load No/ allow filters Yes
fmcontributions - no filter code/ filter on load No/ allow filters Yes
If I change the cotnacts form allow filters to No then when I open the form
from the switchboard I can't go to records and remove filter the function is
locked out.

I checked the VBA for the switchboard for the event procedures and found two
that refer to filters:
1 - On Current
Private Sub Form_Current()
'Update the caption and fill in the list of ooptions.
Me.Caption = Nz(Me![ItemText], '')
End Sub

2 - On Open
Private Sub Form_Open(cancel As Interger)
'Minimize the database window and initialize the form.
'Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] =0 AND [Argument] = 'Default' "
Me.Filteron = True
End Sub

Even when I change the Me.Filteron = False I still have the same problem.
None of the other forms in the tab control have this problem I can open the
main form using the switchboard and click on a tab and make entries and the
command buttons work fine.
I checked the visual basic for filter codes for the cotnacts form and there
is no code refering to filters - The only code is for command buttons

All I want to do is either delete the filter or shut it off so I don't have
to click on the records button each time.
Thanks

--
BillD
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code Needed: Remove Filter, Go To Field, Find Record on Form amywolfie Microsoft Access 2 1st May 2011 12:17 AM
Ac2003 form filter cannot delet, shut off, or even find BillD Microsoft Access Form Coding 0 14th Aug 2008 09:11 PM
A2003 Form Filter cannot delete, shut off, or find problem BillD Microsoft Access Forms 0 13th Aug 2008 05:55 PM
Find Record but Remove Filter =?Utf-8?B?Q0o=?= Microsoft Access Form Coding 8 14th Nov 2006 06:39 PM
remove filter on another form =?Utf-8?B?SmltYm8=?= Microsoft Access Form Coding 1 26th May 2005 08:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:27 PM.