kelly devon 0 Newbie Poster

hi all,
i am creating forms and tables in access using vb code. when i click on ok in one of the forms i want it to open up one of the tables(in acess) and compare certain values. i tried using open "table" for random as #1 .......... but it is not reading the records in the table wat am i doing wrong? and i cant use seek as it is only for table recordsets in vb application
help :sad: