Thread: SQL VBA Query

Trying to get this query to run but having issues....errors out on the FROM statememt

I am trying to incoporate a variable in the SELECT statement...the variable is actually a field in the table

Thoughts?

Code:

Dim varFieldType As String
varFieldType = Combo85
'MsgBox varFieldType

Dim MySQL As String

'MySQL = "SELECT dbo_Core2.'" & varFieldType & "' FROM dbo_Core2 GROUP BY dbo_Core2.'" & varFieldType & "';"

Thats Exactly what I have been looking for...

I was close on my query but was missing the WHERE clause...

I made a query in the query builder to grab jsut the unique values from that field and was going from that....
Either way I was all mixed up....

What you have is exaclty what I was looking for...

THank you very much...your help is very appreciated...

Have a great day....

well, it's kind of a tricky process when you do it that way..... heh you have to have the form control name to put in the criteria of the query, but you can't build the form control until you have the query in place. I usually build the query, then the form, then go back and edit the query to add the form controls. Very little code is needed by the way.

WAIT A SECOND....that was not it...

Sorry about that...

Field 1, Field2, Field3
x c b
x c g
e g l

What I have is a drop down that shows the field names
When I choose Field 3 I want to populate the other drop down box with (b, g, l)
THen if I change the to field1 I want the other dropdown (the same as above) to update to (x, x, e)

That make sense?

THanks for your patience

and help

I can then take these dropdowns and write them to variables to base queries off of...

Field1 X, or Field2c etc

THanks again

Ok, say we have 3 field names....... State, Region, City

You're wanting a combo box to choose the field to populate the other combo box with?

For instance in combo box 1, if I choose city, it will list all cities?
if I choose state, it will list only the states?

If so, that shouldn't be too hard..... I have to do some real work for a bit, then I'll see if I can come up with what you want

Yes as in your example...

The 1st drop down will show the field names (I can hard code them if needed)
After Update
The 2nd Drop down needs to have ONLY the UNIQUE values from that field.

So if you choose State the 2nd dropdown will have California, Illinois, Indiana, Ohio

THANK YOU VERY MUCH....