Dim mvar1 as Integer >Dim mvar2 as String >Dim mvar3 as Date > >mvar1 = Me!text1.value (Number of Cycles) >mvar2 = Me!text2.value (Part #) >mvar3 = Me!text3.value (Production Date) > >Insert into mytable(fld1, fld2, fld3) values(" & mvar1 & ", '" & mvar2 "', ???? >>