Remove the Single Quotes from the criteria expression. It should be


Let strsql = "SELECT * from bidtest where bidnumber = " & CInt(temp)


Single Quotes are used for String & Date Datatypes,...

U r incrementing the value twice. Once in the For (which will automatically increment by 1) and once inside the for loop. So ur icount values are 1,3,5,7... . Since it never reaches 10, it goes into...

2 ways :

You can have the Supplier data (Name, Id) as global variables. From form1 (SelectSupp) set the values of the globals and then open form2(UpdProduct). Then u can access the global...