Where does this Variable get its value

[Lou_Reed]

In the attached file which is an example database where does the variable

Me.txtTicketID g

et its value?



I have looked at the code several times and I am not sure. The only place that I can
guess is the tblHelpDeskTickets. The table that is there at the start of the db use.

I could be wrong, but I am just curious as to where this variable gets its value.

Respectfully,

Lou Reed

[Homegrownandy]

"me" is the form that's currently in focus and the "txtTicketID" I'm guessing is a textbox on that form that contains the ID. (you may need to find it in design view if the visibility of it is turned off.)

[jwhite]

With frmHelpDeskTickets open in Design Mode, open the Property Sheet for Control txtTicketID. On the Data Tab, you will see that the Control Source is set to lngTicketID, which is one of the fields available to the form by the Record Source for the form being set to table tblHelpDeskTickets. lngTicketID is a Primary Key field in the table, and wrongly so it is displayed on the form. The PK is a record reference only and should NOT be seen by the user at all.

Edit: Now I see this is a demo from a website. Demos are demos - not a complete working example, and thus will have issues that need to be resolved before it can be used in a productive environment. For instance, there should be logic built in to generate ticket numbers to reference each ticket. This was short-cutted by the person making the sample and, thus, is a poor example to go by.