Why does the compiler say this variable is undefined

[Lou_Reed]

In the attached file which is my current db why does it say on compile that variable



ysnMeetingID

is not defined in the VBA code.

It certainly is as anyone can see when they open form frmEnail.

This just does not make any sense. I have also attached a screenshot of the affected code.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Bulzie]

I don't see any declaration at top of that code in PDF

Dim ysnMeetingID as Integer

[Lou_Reed]

Does ysnMeetingID need to declared? It is used at least once when the form opens up. At that point
ysnMeetingID has a value of 1. It is used as a control source for one of the text boxes.

I understand that variables must be defined before they are used, but it seems that control source should do the trick instead of explicit variable definition. I guess that I am wrong. Of course I am wrong, but it seems that others get away with it.

Look at the attached db file that I know runs. Look at the txtTicketID variable. I do not see anywhere where it is defined. Yet it is used.

Please explain.

Respectfully,

Lou Reed

[andy49]

in the case of txtTicketID, this is not a variable in VBA.

me.txtticketID is a textbox on the form and so does not need to be defined


stTicketID is being used as a storage area for the value of that textbox and that space needs to be declared using a dim statement.