Hey all,

In the following code
     sql1="select * from tblvbDB where tabID =" & tabid
tabid is a number
But it shows syntax error
wot is the correct syntax??

What is your actual error?
One potential problem is that tabid contains no value.
If the error is "Syntax error (missing operator) in query expression tabID =" then you probably don't have a value in the tabid variable. In other words, tabid is probably holding an empty string, which is a string with no characters and a length of 0.

Woody Z http://www.learntoprogramnow.com