yes/no question

[gmmccarthy]

I have set three yes/no check boxes so I can use them in a query to see if results are in another field.

One example:

After Update Event:

If me.pickupdate.value is not null
me.pickupdateckbox.value = true
end if

This works except it gives the true value to all the checkboxes on every record.

Am I using the me. incorrectly? Does it refer to all the records in the form and not just the current record?

Thanks.

 

[KenHigg]

The problem is that your check box control is not set or bound to a field in the record. The best way I know to do this is to add a 'tag' field in the table and set this as the source field for the check box.

Hope this makes sense...

(Where 'bouts in Atlanta are you? )

 

[gmmccarthy]

Ken,

Thanks. I had created the field in the table but had not entered it as the control source. Duh!!

Another thing, though. It works fine, except, if I make an error and delete the value from the date field, the ckbox remains checked. Can it be set to return to False if the value in the field is deleted. I would guess I need to reference the Not Is Null/Is Null property?

I am currently living in Dunwoody with my ex-wife and daughter and her sister and husbands house. I'm working in Alpharetta.

Gary

 

[KenHigg]

I would think that you could, in the date fld's after update event, do something like:

if isnull(me!myDateFld) then me!myChkBox = false

???