Search results

I have a form set up to where the user can filter everything he needs. Can I set up a report that pulls only the records that are located on the form.??? Thanks to everyone for so much help!! Josh

How would someone go about setting up a form that a user can use to define all the paramaters they want for their query. There are many parameters and I don't want the user to ever touch the query or manually fill a parameter in, so I want the user to be able to fill in the parameters in off of...

Thanks Alexandre But it pops up saying "Wrong number of arguments or invalid property assignment. Should I put DoCmd.ApplyFilter stDocName, , stLinkCriteria before or after DoCmd.OpenQuery stDocName, acNormal, acEdit

Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "multipleselectquery" stLinkCriteria = "[LastName] = 'Reynolds'" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Command1_Click: Exit Sub...

I have built a query named "multipleselectquery" that reads the criteria information from an unbound control box on a form named "multipleselectform". 1 of two values is sent to the query: Is Null ; or Is Not Null. The query will not read these values from the form but it will if I put them in...

When running a query. What value do I use in the "criteria' box to pull off every record. I have to have something in the criteria box, I can't just delete it, so I have to have a statement in the criteria box that will pull all records. Does anyone know what this statement will be. Thanks for...

In my query, for the criteria i pull the information from an unbound text box on a form. The code looks like this in the criteria box. [Forms]![multipleselectform]![RepubUnbound] When the "value" in the unbound text box is "R" , then the query runs fine, but if the "value" in the unbound text...

How would I go about setting up a form with different option buttons that define a query. Say we have a table with a list of democrat voters and republican voters and a user wants just the republican voters. The user presses the option button on the form for republican voters but not for...

I need to know how to change a Combo Box value on a form by using a command button also located on the same form. I thought that possibly I could run a macro using the "set value" function but I couldn't get this to work. anyone have any ideas thanks, Josh

How can I change a control on a form by using a command button. And then how do I call that control from a report?? thanks for any help, Josh

I am trying to pass a value from a command button on a form to a report. I have a form that has 4 command buttons. Each button opens the same report only with different filters. I need to figure out how to also pass a value from the command button to change the Report Title so that the title...