Search results for query: *

Thanks AceMan1 Do you have any code that shows a a combo box with text values to pass to the form filter of the Subform. I can get just plain Text Fields to pass values and query records. For some reason I must not be setting the combo box up correctly. I can't get any records returned when I...

Can someone help me on this code. When I click Submit it pulls all records into my Subform. It doesn't seem to see the value I select from my combox on my main form. Thanks for you help! Private Sub FindSearch_Click() Dim strWhere As String strWhere = "1=1"...

I have a Contact file with Last Name and First Name Field in them. I would like another field that will concantenate these two in a third field automatically I will call Full Name. Having trouble setting up the Full Name field. I sure this is a Calculation. How do I set this up? Thanks

Crowley16 I tried this and it doesn't work. Here is the VB Code for my Event Procedure for my Search Control Buttom. Any Ideas? Private Sub Search_Click() Dim strWhere As String Dim strError As String strWhere = "1=1" ' If Last Name If Nz(Me.LastNameTest) <> "" Then...

I have a Main Form with unbound controls such as LastName, FirstName, City, State,... That I use to input my serach criteria. On the Main Form is a Control Button Called "Search". When I select "Search" with no Criteria in the unbound controls, I get a list of all records in the file in the...