Vba filter not working 3

[Moss100]

Please could someone correct my filter code. Thank you, its driving me mad!! Mark

Me.Form.Filter = "Hol_Staff_Member ='" & Me.cbo_Staff_Initials_Sort & "'" And "[Hol_Year]='" & Me.cbo_Holiday_Year & "'"

 

[dhookom]

I would try this assuming both fields are text.

Me.Form.Filter = "Hol_Staff_Member ='" & Me.cbo_Staff_Initials_Sort & "' And [Hol_Year]='" & Me.cbo_Holiday_Year & "'"

Make sure you set the filter on.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

its driving me mad!!

Help yourself by:

Dim strFilter As String
...
strFilter = "Hol_Staff_Member = '" & Me.cbo_Staff_Initials_Sort & "' And Hol_Year = '" & Me.cbo_Holiday_Year & "'" 
[blue]Debug.Print strFilter[/blue]
Me.Form.Filter = strFilter

And SEE what your Filter is

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[dhookom]

Using Andy’s suggestion, you can copy and paste the expression into a SQL view of a query:

SELECT * FROM [Your Table] WHERE [paste expression here to check]

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Moss100]

Thank you very much Mark

 

[Andrzejek]

So... what was the issue?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[dhookom]

I doubt the line of code compiled because of the errant quotes.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Cole Mendoza]

Hi Mark,

Based on the snippet you provided, it appears you are trying to filter a form based on two criteria: the staff member initials and the holiday year.

Regarding your question about correcting the code, it looks like the code is missing a closing parenthesis after the first criteria. Here is the corrected code with the parenthesis added:

Me.Form.Filter = "Hol_Staff_Member ='" & Me.cbo_Staff_Initials_Sort & "' And [Hol_Year]='" & Me.cbo_Holiday_Year & "'"

Also, if you're still having trouble getting the desired results, you may want to check if the values of the cbo_Staff_Initials_Sort and cbo_Holiday_Year controls are being properly passed to the filter string.



I hope this helps, and good luck with your project!