Where does this variable get its value?

[Lou_Reed]

In the file attached where does the chk_ticket_assigned in the Sub Form_Current get its value initially?



By debugging I learned that it value is 0. But I cannot see where it get its value.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

You mean here?

If Me.chkTicketAssigned = True Then

That's a checkbox on the form, not a variable. That's where the value comes from (more accurately from the field in the table the checkbox is bound to, ysnTicketAssigned).

[Lou_Reed]

I have attached a screenshot of the form's source code. It shows in the Sub Form_Current()

where the code is that I have a problem with. Again where does the VBA program get it value?


Respectfully.


Lou Reed

[jwhite]

Paul clearly advised the answer for you. Maybe this image will help?

[pbaldy]

Again, from the check box on the form.

[Lou_Reed]

Let me explain my situation. In the attached MS Access 2010 db, the value on the frmEmail is determined by the value in the query qryPersonnelMeeting and that value is determined by
what is on the table tblAttendence.

Now I have included two PICs of screen shots of the table tblAttendence and form frmEmail.

In this one the check box on the form frmEmail is checked or unchecked which determined by the table tblAttendence via the query qryPersonnelMeeting.

Now loading the db that I have attached and checking the table tblAttendence to see if the first entry has a check in the box Meeting_invite_sent, I noticed that this has no bearing on what is in the check box on the form frmEmail. They simply operate independently. They are not linked as they are supposed to be.

No matter what you do in the first entry in table tblAttendence, the check box on form frmEmail is unchanged.

That should not be the case. I guess it could be changed by using the requery command, but I have an earlier database that is quite similar (some names of variables are changed from st to str and that is it). and tblAttendence and frmEmail seem to work together.

I have not attached the db where table and form where they work together, but I can if it is needed.

I just cannot understand what is going on.

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[pbaldy]

Tables and unsorted queries can be thought of as buckets of data. They may or may not be in any particular order. If you want the query/form to be in a particular order, apply it in the query. In other words, the form is not opening to the first record in the table, so it will not reflect that record's data. If you add attendance ID to the form, you'll see it's opening to record 132 (at least for me, but as I said it's meaningless with applying a sort.

[Lou_Reed]

I am not sure that I follow you. I have uploaded a zip file of a similar program, with one exception: the boxes on tblattendencee and frmEmail do exactly what I want them to do.

They coordinate perfectly. If i check or uncheck the box in tblAttendence, then it is immediately reflected in frmEmail. Try it, and you will see.

Now why does this one work and the other one I attached from yesterday's post does not work?

I like that this one works, but I cannot guarantee it.

This is fine the one I attached to a post yesterday is not working, why?

There must be a solution to this.

I cannot go with a db that works sometimes - maybe.


Respectfully,

Lou Reed

PS FYI This db came from my home MS Office 20116. Thus it is MS Access 2016. That should not matter.
The one at work is from MS Access 2010.

[pbaldy]

I'm saying you can't count on the order unless you specify it. It might be the same order as the table, it might not. If the order is important to you, specify it in the query.

[Lou_Reed]

Okay, I will try. Tank you very much.

Respectfully,

Lou Reed

[pbaldy]

No problem.