Recent content by pyromaniac

I have gotten the dropdowns to change properly, Where I am struggling is when the query reaches back to look at the current state of the combo box, it doesn't seem to like the all option.

I have a UNION SELECT 0, ' All' FROM tblBrands so that I get an all option in my dropdown. I also have a [Forms]![frmMain]![cboBrands] in my query criteria to filter results from the combo box. When all is selected, I get no results. I'm thinking I need an if statement. if all is selected, run...

Added some spaces before quotes and an extra 0 in the select statement. BrandsSource = "SELECT [tblModels].[Model_ID], " & _ "[tblModels].[Model_Name], " & _ "[tblModels].[Brand_ID] " & _ "FROM tblModels " & _ "UNION " & _ "SELECT 0, ' All', 0 " & _ "FROM tblModels "

I tried adding a select all into this but get a FROM error any idea what is causing this? Dim BrandsSource As String If Me.cboBrands.Value = " All" Then Me.cboModels.Value = Null BrandsSource = "SELECT [tblModels].[Model_ID]," & _ " [tblModels].[Model_Name]," & _ " [tblModels].[Brand_ID] " &...

Time to admit the stupid simplicity of my error. Being base 0 and needing the ID, I was searching Column 2 which did not exist when I needed to be looking at 0. Dim BrandsSource As String BrandsSource = "SELECT [tblModels].[Model_ID]," & _ " [tblModels].[Model_Name]," &...

yea, I noticed that too... Sorry, JS background. SQL confuses me:banghead:

ok, thinking out loud... I should have been in the WHERE not the SELECT.

I think I posted a screenshot of layout. I'm trying the following code to filter the second combobox. Dim BrandsSource As String BrandsSource = "SELECT [tblModels].[Model_ID].Column(2)," & _ " [tblModels].[Model_Name]," & _ " [tblModels].[Brand_ID] " &...

I went back and edited it to say column but you replied too quickly. I found this on a SO page that I'm going to try. YourVariable = Me.cmbEmps.Column(2) if that fails I will make a picture.

I have a form that has 2 combo boxes so far (brand and model). I need model to filter when brand is chosen and I need to pull the data for a query. when the bounded column is 1, my combo box filter works. when bounded column is 2 my query works. Is there a way to leave it at 1 and make the query...

Im going to fiddle with your example at home with a cleaner DB. I have been learning Access and database stuff while building this project so there is a lot that isn't done right but works. One thing I noticed while fiddling was that not all of the records were showing up. Over the last week...

Ok, rebuilt the subform, Tinkered around a bit. started undoing my changes and it started working. I have no idea what fixed it, my co-worker says F'ing Magic.

I'm wondering if with all the changes to the table that maybe I should rebuild the subform. I may be working in circles right now.

Ok, fresh eyes. Lets see If I can figure this out today. vbaInet: I didn't know you could do an excel front access back. I knew the reverse was possible. Anyhow, it is all in access. This project is converting a bunch of excel stuff into one database where the reports make themselves. As for...

I had 3 drop down filters that worked when the word being filtered was written in the table. I have since then linked them to new tables to be more database-y. The problem I have found (a couple weeks later too) is that my drop downs broke. It makes sense why, they are now 1,2,3,4 instead of...