Check Box

[papic1972]

I have check box on a main form (with its property type set to true/false). I also have a command button (placed next to this box on the form and is not linked) that when pressed pops-up a special comments pop up form.

I would like to be able to automate the check box, so if there is nothing typed in the special comments box, then check box should remain unchecked. Likewise if there is info typed in the special comments form, then I want the check box to be automatically checked.

Does anyone have an idea how to do this.

 

[dzepeda]

Try putting this in the on change event procedure of your text box:

Me![MyCheck] = (Len(MyText.Text) > 0)

Where MyCheck is your Checkbox Name an MyText is the textbox you want to link.

 

[papic1972]

It doesn't seem to work.

The checkbox control source is from a table called tblOrderInput. The special comments control source comes from a linked table called tblOrderInputPrelim.

Do you think that this could be the problem.

 

[authorsami]

Is there a way to have a check box be check automatically if a certain field meets a certain logic requirement....

OK, sorry, in plain English this is what I need it to do if possible.

I have a table with sales history. One field in this table is the date of the appointment another is for a date in the future when they need to come back for another appointment. I have a check box that is for if they keep the second appointment. I would somehow like it if when a new appointment (sale) is made that it will check the previous date (sale) and check the box for that record. Does this make any sense???

I'm trying to make it so the user will not have to go back into the history and find the old record and put a check box in that record. Later I'm pulling a report to give me people who should have made an appointment but did not. to do this I'm pulling all with a date < now() and the check box = no. but it would be nice if the check box was automatically check if an appointment was kept after the follow up date..... I know I did not explain this right, but if any thinks they could help I'd love to hear from them.

Sharon