update query

[Boysie]

I am creating an exercise database for instructors to use. Pretty simple -
they select an exercise using a tick box from a continous form and it prints
the selected exercises in the report. I have tried creating an update query
to deselect all the boxes but for some reason when i run the query it only
deselects the boxes when I hover the mouse over the tick box or when i click
the mouse on the record line. Any ideas?????

 

[Ken Snell MVP]

Show us the SQL statement of the update query that you're trying to run. How
are you running this query -- by macro, by VBA, other means?

 

[John W. Vinson]

I am creating an exercise database for instructors to use. Pretty simple -
they select an exercise using a tick box from a continous form and it prints
the selected exercises in the report. I have tried creating an update query
to deselect all the boxes but for some reason when i run the query it only
deselects the boxes when I hover the mouse over the tick box or when i click
the mouse on the record line. Any ideas?????

An Update Query updates a table - *not* a Form. A checkbox isn't a field
value; it is a tool for displaying field values.

What's the Recordsource for your form? What are some representative Control
Sources for the checkbox controls? I suspect that you've fallen into the very
common trap of "storing data in fieldnames" - do you have a bunch of Yes/No
fields in your table, one for each exercise? If so you're on the wrong
track...

 

[Boysie]

Guys

Thanks for the replies. Im really not great with access so what you have
said has gone straight over my head. Would it be possible for me to send a
copy of the database to you for you to look at?

 

[John W. Vinson]

Guys

Thanks for the replies. Im really not great with access so what you have
said has gone straight over my head. Would it be possible for me to send a
copy of the database to you for you to look at?

Well, that would typically require a consulting contract. I'm a self employed
database developer, donating (a good bit too much) free time on the
newsgroups. If you're interested let me know and I'll send you my terms.

Let me try again - if you post a bit more information about your database here
you can probably get some help for free.

How are your tables structured? What tables do you have? What are some
representative field names and datatypes? How (if at all) are they related?)

Open your form in Design view. View its Properties. What is the Recordsource
property? If it's a query, click the ... icon by it to open a query design
window; select View... SQL and post the SQL text here.

Then click on one of the checkboxes. What is that checkbox's Name? What is its
Control Source property?