jkoneil
asked on
Create a check box on a continuous subform
Hi everyone! I have been trying to get this to work and have not been able to. I am sure I am missing something and would greatly appreciate any help.
I created a form which contains a continuous subform based on a query. I created a check box for each row but when I click on it, all of the rows are checked/unchecked. I could not figure out a way to bind the check box to the query (it is a pass through query to Oracle) so I bound it to a separate table. When I try to check the box, nothing happens except for a message appearing in the corner that the Form is read only. The table I bound the check box to is not read only.
I think that is everything, please let me know if you need additional information.
Thanks,
Josette
I created a form which contains a continuous subform based on a query. I created a check box for each row but when I click on it, all of the rows are checked/unchecked. I could not figure out a way to bind the check box to the query (it is a pass through query to Oracle) so I bound it to a separate table. When I try to check the box, nothing happens except for a message appearing in the corner that the Form is read only. The table I bound the check box to is not read only.
I think that is everything, please let me know if you need additional information.
Thanks,
Josette
What is the purpose of the check box ?
mx
mx
ASKER
I should have been clearer, I bound the check box to a field in the table.
When the user checks the box a row is inserted into a temp table. If they uncheck it, the row is removed from the temp table. Once they check all of the rows they are interested in, they click a button to insert the rows from the working table into the actual table.
When the user checks the box a row is inserted into a temp table. If they uncheck it, the row is removed from the temp table. Once they check all of the rows they are interested in, they click a button to insert the rows from the working table into the actual table.
I see.
ok ... in the table to which the query driving the subform is connected, to ... add a Yes/No field in that table - lets call it RecSel or RecChk. Then, on the form - make that field the Control Source for your check box.
mx
ok ... in the table to which the query driving the subform is connected, to ... add a Yes/No field in that table - lets call it RecSel or RecChk. Then, on the form - make that field the Control Source for your check box.
mx
ASKER
Is there another way to include a Yes/No field in the query? I can't add a field to the table.
Thanks.
Thanks.
"Is there another way to include a Yes/No field in the query? "
Not really, because any 'fake' field you add to the query will not be updateable, ie you won't be able to check it.
I understand what you are trying to do, but the way I do this sort of thing is by having that RecSel field in the table.
mx
Not really, because any 'fake' field you add to the query will not be updateable, ie you won't be able to check it.
I understand what you are trying to do, but the way I do this sort of thing is by having that RecSel field in the table.
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hey Leigh ... MIA!
"picture two users simultaneously selecting rows for whatever reason -"
Mine would be accompanied with a UserID of course.
mx
"picture two users simultaneously selecting rows for whatever reason -"
Mine would be accompanied with a UserID of course.
mx
ASKER
I was able to create a local table and use that as the record source of the form rather than a query. I use a query to populate the local table based on a selection in a dropdown list and then delete the content when the user is finished making their selections and updating the database. It worked well in the tests that I ran anyway.
Thanks for your help.
Thanks for your help.
ASKER
Thank you for your help. I really needed to work this out.
Josette
Josette
Well, there is only one physical control. So, without a control source, that's what happens. You can't really bind a control to an entire table, only a field in the table.
mx