Search results

I'll give it a try. No, the list box is not on a subform. Thanks. Bruce

I was hoping Nero's response to the DLOOKUP question would help solve my problem... BACKGROUND: The Form (frmSearch) has two sections. One side consists of 7 check boxes and the other side is a listbox. Each time a check box is checked, a requery occurs, updating the records that match the...

Something similar Dev, I created a dialog box where all the query options were Yes/No. CheckX, CheckKa, etc are the check boxes on my form, qryModemSearch is the query that's modified in the process... Hope this helps. Bruce ______________________ Function ChangeQueryDef(strQuery As String...

Thanksw for the help... I was headed in the right direction, just got hung up on the order (can't help it, I've only been doing this since Monday). The code works great as long as DoCmd.OpenForm is executed before Forms!FrmModemSpecs.NavigationButtons = False. Thanks again to everyone who...

I'm sure this is an easy one, but I'm pulling out my hair trying to make it work. BACKGROUND: I'm using Access 2000 and am opening a form through using a dialog box with 2 command buttons. One of the buttons opens a specific record (selected from a list), and the other cmd btn opens them all...

It works! Here's the code... Function BuildSQLString(strSQL As String) As Boolean Dim strSELECT As String Dim strFROM As String Dim strWHERE As String strSELECT = "s.* " strFROM = "tblTerminalSpecs s " If CheckX Then strWHERE = strWHERE & " AND s.[x-band] =" & True End If If CheckKa Then...

Thanks Hayley! I'll give it a try and let you know how it works. Thanks again. Bruce

Partial answer... Okay, here's what I did, but I'm still not all the way there. I used the expression builder in the query criteria section and entered the following: [Forms]![FilterForm]![CheckX] (I did this for each of the criteria). Now, my problem is only the records that are an exact...

I'm familiar with it, but I'm trying to make this as easy as possible on the user by limiting the fields that can be searched, hence the check boxes. If you think, there's a way to use filter by form that may work, please let me know. Thanks. Bruce

I'm still new to MS Access and VB and am struggling to get my search page working. Does anyone know how to to return records that match multiple criteria? Here's how things are set up... My table, ModemSpecsTbl, has various fields that are yes/no. Examples of fields include XBand, KaBand...