using variables in queries

[developing]

hello all

how do i use a variable in a query for the 'criteria'? i can easily do this in vba, but im trying to avoid using code right now...dont ask...i hate it too....lol

thanx

[Denburt]

Not really, I need to know where this variable would get it's information from? If it is user input the in the criteria section place the following:

[GIVE ME MY CRITERIA!!!!]

Now if you want to extract it from an open form:

Forms!MyForm!MyField


Does this help?

[developing]

wow tha twas fast...not really tho, im using a global variable that has infromation about a user.

i looked around thru google. turns out i kinda HAVE to use code...so got this

someone make sure pls? i need the row source to be NAME1 where ADIENST is gblUSER. The bound column is suppsed to be ID....
all in the same table. also, id like it so only NAME1 was displayed in the cbo....

With Me.cboCustomerName
.RowSource = "SELECT NAME1, ID" _
    & " FROM SYSADM_KU_KUNDEN " _
    & " Where  [ADIENST] = " & gblUSER _
    & " ORDER BY SYSADM_KU_KUNDEN.NAME1;"
.BoundColumn = 2
End With

[Denburt]

Looks O.K. as long as both fields below refer to a number.

& " Where [ADIENST] = " & gblUSER _


If Text then

& " Where [ADIENST] = '" & gblUSER & "'" _


Good luck let us know how it goes.

[developing]

works like a charm thanks!

yeah i was missing the string syntax....thanx again

[Denburt]

No problem glad I could help.

[MMcCarthy]

No problem glad I could help.

Actually there is an easier way of doing this.

Assuming a global variable of

Global i As Integer

Then this function

Function getGbl()
 
    getGbl = i
 
End Function
 

You can now simply use getGbl() as the criteria on your field.

Mary

[developing]

Actually there is an easier way of doing this.

Assuming a global variable of

Global i As Integer

Then this function

Function getGbl()
 
    getGbl = i
 
End Function
 

You can now simply use getGbl() as the criteria on your field.

Mary

so SQL takes in functions as parameters eh? sweet, definately gonna help me later on. Thanks