RowSource property

[radek225]

How could I put variable in WHERE?

dim waga as byte
[COLOR="Red"]waga[/COLOR] = me.status.column(2)

me.kombi11.rowsource = "SELECT [tblStatus].[Id_Status], [tblStatus].[Status], [tblStatus].[waga], [tblStatus].[uprawnienia] FROM tblStatus WHERE tblstatus.waga < [COLOR="Red"]waga[/COLOR];"

 

[pr2-eugin]

like this you mean?

Me.kombi11.Rowsource = "SELECT [tblStatus].[Id_Status], [tblStatus].[Status], " & _
                       "[tblStatus].[waga], [tblStatus].[uprawnienia] FROM tblStatus " & _
                       "WHERE tblstatus.waga < [COLOR=Red][B]" &[/B][/COLOR] waga

 

[radek225]

thx!!!!!!!!.

 

[radek225]

I forgot about order by, how can I put it in to a code? "order by tblstatus.lp"

 

[pr2-eugin]

Something like..

Me.kombi11.Rowsource = "SELECT [tblStatus].[Id_Status], [tblStatus].[Status], " & _
                       "[tblStatus].[waga], [tblStatus].[uprawnienia] FROM tblStatus " & _
                       "WHERE tblstatus.waga < " & waga [COLOR=Red][B]& " ORDER BY [tblStatus].[Status]"[/B][/COLOR]