Change field to checkbox

[PB90]

I have a subform, based on a query. I want to add a new field (Y/N) which I am setting to no on the initial query. I did that by creating a field blnDel: "blnDel: CBool(0)"

I would like to make the subform show the field as a check box. I am not sure how I can do this (that option doesn't appear in the "Change to" option list)
Is there a way to create it that way in the query? Or another way to accomplish this?

 

[GShen]

Did you go to the toolbox and press the checkbox field? You can add it and then delete the other field you have on your form.

Remember when... everything worked and there was a reason for it?

 

[PB90]

Yes, I tried that, but it just beeps at me when I click the box (probably because it is based on a query). I guess I will have to change it somehow to an update?? query. But I'm not sure how that would work.

 

[GShen]

When you click on the check box, you then have to go to your form and click on the form and it will place in where you click. Is that what you did?

Remember when... everything worked and there was a reason for it?

 

[PB90]

It will not do anything but beep at me when I try to click on that field from the form. It will NOT place anything in that "place" where I click.

 

[GShen]

Can you click on it on other forms?

Remember when... everything worked and there was a reason for it?

 

[PB90]

I don't have it in other forms, this is the only place it needs to be used.