What is this difference between these?

[Lou_Reed]

In the file that I have attached is a db that I know works. I am curious as to what is the difference between chkTicketAssigned and ysnTicketAssigned. The are in the form HelpTeskTickets.



I know that chkTicketAssigned is the name of a Sub, but is it used any other way? I also know ysnTicketAssigned is a control. The db works fine.

Any help appreciated. Thanks in advance.

[pbaldy]

chkTicketAssigned is a checkbox control on the form. ysnTicketAssigned is a field in the table. The checkbox is bound to the field, so changing the value of the checkbox changes the value of the field in the table.

[pbaldy]

By the way, both of these statements are incorrect: "I know that chkTicketAssigned is the name of a Sub...I also know ysnTicketAssigned is a control.". The control is named "chkTicketAssigned", the sub is "chkTicketAssigned_AfterUpdate()". The "AfterUpdate" bit indicates which event of the control it is. "ysnTicketAssigned" is a field in the table, represented by the control.

[Lou_Reed]

Okay, the Sub is named as you said is named chkTicketAssigned_AfterUpdate. Thus the part check chkTicketAssigned is control, could it be a method?

You are right about ysnTicketAssigned . I apologize for the error. It does seem that they do similar things.

I would have used a different naming convention.

R,

Lou Reed

[pbaldy]

Thus the part check chkTicketAssigned is control, could it be a method?

Not sure what you're asking. It is a control, not a method. This shows the events and methods associated with the checkbox control:

https://msdn.microsoft.com/en-us/lib.../ff194967.aspx