Search results

Thanks again Devastation. I got it to work (although I had to add a "WHERE" into your line after the "FROM Table1"). You are really good at this stuff. The only thing I have to figure out now is how to get my listbox to display detailed information in a subform like it did before, but I'm sure...

Hello Devastation, I'm sorry, but I have another question. I'm trying to use the same code to filter a listbox on my form, but when I hit the filter button, I get a blank listbox. Can you see what I'm doing wrong? Private Sub Command20_Click() On Error GoTo Err_Command20_Click 'Button...

I'm not sure how having "cascading combo boxes" would help. I don't know if my post was confusing, but attached is a better example of what I want to do. It's a little more complex on the back end I'm sure. Basically, I want to give a person the option to filter a listbox by any column and...

I've messed with creating a filtered report. But it was simplistic in that it only filtered by "equals". Is it possible to create a filter form that filters using the example I have attached?

Hello, I know the following code will refer to a txtbox within a form ([Forms]![frm1]![fld1]) But how do I refer to a txtbox within a subform within a form?

By typing criteria into a text box or selecting preset criteria from a combo box. Simple Example Attached

Hello, I've recently learned from another user (thanks Devastation) how to filter a report using a form with textboxes/comboboxes where I can enter criteria into those boxes and hit a "preview report" command button. Is it possible to filter a listbox similarily?

If it slows down the application too much, maybe I shouldn't use it then. No big deal. Thanks for the response.

Hello All, I was wondering if there was a code to place on a textbox so that when I begin to enter text into the box, it brings up previous field entries in that column that begin the same way (just like Excel does when you begin typing a word that appears in the same column somewhere...

The mistake I was making was: "( [Country] = [Forms]![frmSearch]![txtCountry]) AND " I didn't realize that "Country" referred to the textbox in the report. I thought it referred to the column in the report - and thus didn't matter. My mistake. Your code works exactly as I hoped. Thanks for...

Hey Devastation, Thanks, I'll try it out and see how it goes. I appreciate all the help you're giving.

I tried the recommendation and wasn't successful. I noticed you said it may be possible to write if statements inside a query. That's what I thought too. I just don't know how that would appear. I'm still working to figure it out.

I think I figured out the problem - to a point. I know that if I set the query to only filter by one field, then the filter works. If I try and set the query up to filter by many fields, then the filter doesn't work. I'm guessing that's because I don't enter data in some of the fields to filter...

I tried your recommendation, but I'm doing something wrong because it comes up with an error and then clicking on the report button sends all records to the report still. I attached a scrubbed version of the db (without company data) to show you what I'm attempting to do. The "Ticket Requests"...

Does anyone know where I can find a sample of how to create a form with combo box selections (for selecting tables and fields) and textbox (for entering in desired values) to generate a filtered report?

My apologies. I must be dislexic or something like that.

Thanks for the help. That was it. My post must've been confusing, but I knew the second box had to be a textbox -

I did a search earlier and I saw plenty of cascading posts where someone wanted to narrow their search in cbo2 based on their selection cbo1 (I was one of them), but this table is the other way around where I want the fld1 selection in cbo1 to display (not give options) fld2 of that same record...

If I have one combo box that displays values from a primary key field (fld1) in a table, how can I set the second combo box to automatically display whatever is in the second field (fld2) of that same record?

You're most likely right on this one. Since fldAuto is a numeric field. I'll try it when I get to work. Thanks for the help.