declare variables

[fenster]

Hi Guys - This is a vb question , but this forum has always helped me in the past so im gonna post it anyway..

heres my problem..

i will show u the way im trying to do his - one of u can rubbish it and hopefully give me what im looking for....

Ok - I have a label in form 3 , it has a value i want to use in a class module..

lblInvCustomer2.Caption = goRsComplete!jobID (this value)


then i have the code jumping to a class module..


the line in the sql statement of the module reads

sSQL = sSQL & " WHERE (((Transaction.JobID) = '" & JjobID & "'))"

what i want is for the jjobid to equal the value of the label from form 3 .

i know i have to dim but dunno what scope etc.

i keep getting variable not defined and all sorts



any takers?

 

[Ziggy]

Try it with Public Sub if you have it as Private

Where is the Variable declared? Declare it in the Option Explicit area outside of the Sub might help.