Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Setting Query Criteria based on VBA
hmm, wasnt working before.. but thank you sir. Problem solved.- ablunk
- Post #7
- Forum: Microsoft: Access Forms
-
Setting Query Criteria based on VBA
What is the control I have to put this under to disable the listbox when the button is activated? if me.optAll.value = true then cmbPrinter.enabled=false else cmbprinter.enabled=true endif Then you get a star my friend.. that first code worked like a champ.- ablunk
- Post #5
- Forum: Microsoft: Access Forms
-
Setting Query Criteria based on VBA
ON THE BUTTON CLICK: If optAll.Value = True Then Me.txtPrinter.Value = "Like '*'" Else Me.txtPrinter.Value = Me.cmbPrinter.Value End If DoCmd.Requery PrinterQuery [Forms]![frmPrinterQuery]![subPrinter].Visible = True End Sub Query Criteria: [Forms]![frmPrinterQuery]![txtPrinter]- ablunk
- Post #3
- Forum: Microsoft: Access Forms
-
Setting Query Criteria based on VBA
Ive scoured the boards for an application of what I'd like to do.. but i'm obviously missing something or going about it wrong.. So I have a list box on a form that has an indexed list of NAMES, that allows a selection of 1-4.. I also have a option button that, if selected, outputs all...- ablunk
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
