Recent content by rwrig

So I should get rid of the additional form and make browse all issues form the main search form?

Name of Controls? Are you talking about the ones on my form if that's the case the names are all the same as the labels if you look at my code above.

Bare with me BlueIshDan I'm a bit of a novice when it comes to access, When you say table being queried? I created a form (Browse All Issues) that takes all fields from the table (Issues) except for one (Edit Field is unique). So when you say the table being queried is it the Issues table or...

So what info do you need again?

I'm trying to query the Form Browse_All_Issues with record source is "Issues Table". I attached a pic of the browse_all_issues records. I have a for Search Issues which has the list drop down buttons and the detail section is "Browse_All_Issues, I will like to use the drop down in Search...

No the below is another sub form of the table

BlueIshDan if you look at the snap shot I will like to use the drop down criteria to filter the records below by clicking search.

Cronk how do I do that?

I have a form called "Search Issues' and a Subform within call "Browse All Issues". Browse All Issues Record source is a table that contains all the data called Issues. I'm trying to create search features within "Search Issues" where I can select multiple criteria from List box and when I...

So how do I set up the code to get the filters on the form to returns the results on my form that displays on the source table?

Paul your right the source table is Browse All Issues and its in the footer on the form. So should I set up each search parameter like: If(Len(Me!Subform1.Browse_All_Issues.AssignedTo & "") <> 0, "([AssignedTo] Like ""*" & Me!Subform1.Browse_All_Issues.AssignedTo & "*"") AND", "") & _

Hello All: I have the below VBA in a from for it to filter the records below based on the criteria: Private Sub Search_Click() Dim strWhere As String strWhere = IIf(Len(Me.AssignedTo & "") <> 0, "([AssignedTo] Like ""*" & Me.AssignedTo & "*"") AND", "") & _...

First Error I received was Compile error: invalid use of Me keyword.

When I highlight the code and click run it brings up the macros box. See attachment.

As of right now I'm not seeing a debug issues because when I click the button the even procedure isn't running do you know why this issue can be happening?