Im alway 1 step to late

[alaric]

Hi
I am using the following code to select rows in a countinuoes from. It is used as a filter for printing my reports.

DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunSQL "UPDATE TAfdansen SET TAfdansen.[Selecteer] = True WHERE (((TAfdansen.[Select])=False));"
DoCmd.RunSQL "UPDATE TAfdansen SET TAfdansen.[Selecteer] = False WHERE (((TAfdansen.[Selecteer])=True));"
DoCmd.Requery

Problem is that the table is updated with the flag to true after I checked/unchecked the next.
So Im always 1 step beyond (madness )

How can I fix this

any suggestions are more than welcome

Alaric

 

[WayneRyan]

alaric,

DoCmd.RunSQL "UPDATE TAfdansen SET [Selecteer] = Not [Selecteer]"

Wayne

 

[alaric]

now I'm lost

Wayne,

I made a mistake when pasting the code.
This part works ok. it is for selecting/deselcting all records.

the problem is:
I have a bound chkbox in this cont. form in the detail section.

So here happens the "funny" part.. i klick a chkbox box .. nothing happens... i click next ckkbox .. the previous action is updated in the table etc..

this form is base on a query (in the recordsource).. is it possible that it has something to do with that
any ideas?

Alaric

 

[WayneRyan]

alaric,

It sounds OK, continuous form, bound control.

Can you possibly:

Remove unneccessary stuff,
Compact/Repair the database,
ZIP into a file,

Then post it here ...

Wayne

 

[WayneRyan]

Alaric,

Darn, I always forget to attach too.

Wayne

 

[alaric]

db Size

Wayne

I thought I did attach...
upload size is 100k... cant get the Db under 288

suggestions?

A

 

[WayneRyan]

Alaric,

Did you follow the steps in the previous post?

Most databases can fit within 100K. Remove any graphics. Compact/Repair,
then ZIP into a file.

Wayne

 

[alaric]

Late response

Wayne

sorry for my late response, I left a message in your mailbox that my DB could be downloaded through my website. You may have missed that one.
Do you still want to help me? please

Alaric

 

[WayneRyan]

Alaric,

I downloaded the database, and it seems to work fine. When I
Check/Uncheck the Checkboxes, the tables look fine.

One point. If you do Tools --> Database Utilities --> Compact/Repair
the database will shrink dramatically. Also, the Repair part might fix
your problem, as it works fine on my machine.

Wayne