Search results for query: *

I have a report based on a query that the user filters by year by selecting an Option button on a form. I would like the report header to be specific to the year selected by the user. I've currently got an unbound text box that formats the Report Header - (if [DateRequested] Between #1/1/2009#...

I KNEW there had to be a simple solution - here is my final code: Private Sub cmbFindEmployee_NotInList(NewData As String, Response As Integer) 'If this runs, we KNOW we want to add a new record Dim strMessage As String strMessage = "That employee is not in the list." & vbCrLf &...

Thank you for both suggestions, but they're not quite getting me where I'd like to be. The cmbFindEmployee combo box is sorted by last name, first name - so the user can tell pretty quickly after beginning to type the last name if the employee is in the list or not. The form is based on a table...

I have a form for entering employee contributions (frmContributions) that contains an unbound combo box to search for employee names (from tblContributors). If the user enters a name that is not already part of the list, I want to give the option of adding a new employee directly on this form...

Duane - thanks again!

lameid - thanks for pointing me in the right direction! Concatenating the criteria solved the problem - our users will never have an "or" situation as all three choices are required. Code that solved the issue: strAddCriteria = "(" & strFilter1 & ")" & " and " & "(" & strFilter2 & ")" & " and...

I would like for the user to filter the data on their report by making selections from 3 separate Option Groups: Year, Type, and Status. I've set up a form with all three Option Groups on one tab control; then included a Preview command button to set the criteria and open the report in...