i got a type mismatch run time error 13 in the following line of the load event of my form... pls help me

set rs=db.OpenRecordset("SELECT * FROM STOCK")

Can you please share some more of your code, as db and rs definition?
Type of database..
Did you clearly define recordset as ADODB.recordset or DAO.recordset...?
If in preferences is DAO in priority of ADO db type then you could receive this type of error.

need more information. so please share it.

i gave my table name wrong and so got this error.

commented: For solving your own problem.:) +7

:)

Small things normally causes the worst headaches. Glad you could solve this.