Unbound check box on continuous form

[Rpschwar]

Yes I have, it just will not let me attach a file. Is there some option I have to select to allow for attachments?

[CJ_London]

Not so far as I am aware.

Either way, attaching your db will not solve the problem - you have described the issue adequately and solutions have been provided. You cannot do what you are trying to do with an unbound checkbox

[Rpschwar]

Yes I did both 3 and 4 and it will not attach. Is there anything I have to do to allow for attachments?

[Rpschwar]

I currently have it working in Coldfusion, but I having to change it to Access. That seems to be a short coming of Access to not allow it.

[June7]

If the checked box is not associated with data from record how would you expect Access to know which records you want to work with? Cold Fusion is not a database. It is a web development tool that can interface with database. I don't know what Cold Fusion code is doing but you cannot compare with Access as the two programs are completely different and serve different purposes.

[Rpschwar]

You should not have to tie the control to the database. You should be able to create a separate checkbox control on each line that will know the ID's you are working with so you can later see which items you have selected.
i got it to work by creating a temporary table but it would be better if I could just have an unbound checkbox control. I have an unbound textbox that is populated from a function call to the database so why can't I have a checkbox do the same thing?

[June7]

That function is called from the textbox ControlSource property? And does that function have a variable input pulled from the record and is used to calculate a value returned to the textbox?

Your checkbox is not based on any variable input, it is directly set by user. There is only one checkbox control on the form therefore all instances of the control will reflect the same user selection because there is no variable input.