B
BillD
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
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