Variabe small question

[Madmax2]

Why do i get invalid qualifier in the below code...

private sub command29_click()

on error goto errorcode2
dim clock1 as long
if isnull(clock#) then
goto errorcode1
else
if isnull(part#) then
goto errorcode1
else
clock1=clock#.value
docmd.gotorecord , , acnewrec
clock#.value=clock1
endif
endf
exitsub
errorcode1:
msgbox"error1"
errorcode2:
msgbox"error2"
endsub

i get it at clock1=clock#.value

[Madmax2]

Btw i had to retype bto my ipad because my work computer isnt connected to internet so posible mistakes in code point them all out just in case. Thanks. Max

[John_G]

The only thing I can think of is that Clock# is not the name of a control on your form, in which case Access treats it as a numeric variable, which does not have the .value property. If Clock# is correct, try using Me![Clock#] to reference it, without using the .value part.

John

[Madmax2]

Yeah i goofed and found what happen. Clock# is the control source for combo35. I got it working after all. Thanks for the reply.