Alphabet buttons remove filtering...why? 1

[AccipiterQ]

I have a switchboard form in my database with several buttons on it. Each button opens the main form for the database and displays only a certain set of records...it's using a VBA filter. Now along the bottom of the main form is a set of alphabetical buttons, basically it's to show only those who have a last name of 'a, b, c' etc. you get the point. However when I hit the alphabetical button, it removes the filter that the switchboard form applies...is there any way around htis...so that the filter is still applied, and when the alphabet button is hit, you only see those with a last name that starts with say, 'A' within the filtered selection? The alphabet buttons are linked to a macro...and here's an example of the switchboard button's VBA:

Private Sub AFP_Button_Click()
On Error GoTo Err_AFP_Button_Click

Dim stDocName As String

stDocName = "Master List: Businesses"
DoCmd.OpenForm stDocName, , , "[From]='AFP'"


Exit_AFP_Button_Click:
Exit Sub

Err_AFP_Button_Click:
MsgBox Err.Description
Resume Exit_AFP_Button_Click

End Sub

the "[From]='AFP'" is what filters out the other records so that only entries with 'AFP' in the From field show up.

 

[Crowley16]

there's 2 options

1) combine both the switchboard filter and buttons filter into one single filter, which should then be applied to the form upon a button hit

2) apply the button filter only the the recordset of the opened form

I'm not 100% sure the 2nd method will work though...

--------------------
Procrastinate Now!

 

[AccipiterQ]

I don't suppose you'd know how to combined the two filters into one...I'm not exactly a pro with VBA

 

[Crowley16]

with the keywords AND + OR...

blah = value AND otherBlah = moveValue

--------------------
Procrastinate Now!

 

[AccipiterQ]

hmm wouldn't I have to program it for each letter of the alphabet then along with each button on my switchboard form...i.e. a button for clients from a Turkey Drive we had that began with the letter A, then another button for letter B, etc. ?

 

[AccipiterQ]

I basically just don't want the filter applied by the switchboard to be removed when I hit one of the alphabetical buttons after the form opens.

 

[AccipiterQ]

anyone?

 

[TheAceMan1]

How are ya AccipiterQ . . .

The easiest thing I see you can do, is [blue]make a query for each filter button[/blue] on your switchboard and [blue]apply the approriate query to the RecordSource of the Main Form[/blue].

[blue]   DoCmd.OpenForm "MainFormName"
   Forms!MainFormName.RecordSource = "QueryName"[/blue]

In this way your alphabet filters should work as is ([blue]you'll be filtering the query[/blue], instead of overwriting the previous filter set by the switchboard.

When you try this, don't forget to save the Main Form with an empty RecordSource 1st! (just to remove interaction).

See Ya! . . . . . .

 

[AccipiterQ]

It appears successful! Thank you very much, I'm going to tinker with it and see if it continues to work appropriately!