Error - The data has been changed

[philelpko]

The first line in the code I sent you...

   
Me.Requery

Is the same thing. You don't need Parent because you're on the main form.

Rather silly question of me to ask in hind sight!

[MMcCarthy]

Rather silly question of me to ask in hind sight!

Don't worry about it.

More importantly, does it solve your problem?

Mary

[philelpko]

Don't worry about it.

More importantly, does it solve your problem?

Mary

Nope, still get the same data error message even with the Me.requery in the On_click event.

I think that I am going to have to re-do my main form but this time not hide the forms one behind another. What way would you recommend laying out a main form with 3 subforms (only 1 subform is allowed to be viewed at a time).

I think the main prob with this database is that its the 1st one i have ever designed and I keep finding quicker and easier ways to write code that I wrote the week before, so I am thinking of just re-writting the whole thing!!

Cheers for all the help Mary :)

[MMcCarthy]

Nope, still get the same data error message even with the Me.requery in the On_click event.

I think that I am going to have to re-do my main form but this time not hide the forms one behind another. What way would you recommend laying out a main form with 3 subforms (only 1 subform is allowed to be viewed at a time).

I think the main prob with this database is that its the 1st one i have ever designed and I keep finding quicker and easier ways to write code that I wrote the week before, so I am thinking of just re-writting the whole thing!!

Cheers for all the help Mary :)

You could use a multi page object.

Before you scrap the idea completely, change your click boxes to command buttons. This is what I used when I was hiding/unhiding subforms. It may make a difference.

Mary

[philelpko]

You could use a multi page object.

Before you scrap the idea completely, change your click boxes to command buttons. This is what I used when I was hiding/unhiding subforms. It may make a difference.

Mary

Mary you are a god send!!!

I never have tried changing the check boxes to command buttons as i figured it wouldnt make any difference as the both worked on "on click" events.

Works a treat now!! Thanks massively.

[MMcCarthy]

Mary you are a god send!!!

I never have tried changing the check boxes to command buttons as i figured it wouldnt make any difference as the both worked on "on click" events.

Works a treat now!! Thanks massively.

At a guess I would say with the tickboxes Access was attributing values to them whereas it doesn't with command buttons.

Mary

[NeoPa]

Fascinating thread.
Who would have thought Access would behave so unpredictably ;)
Nice work getting it sorted out - particulary Mary.

[SBroekmeulen]

Really Fascinating,
I have a same sort of problem but I do need Checkboxes, since they do Hold Information.

I have a subform with analising results, which is initially filles with default values. The checkbox tells me wether to print the results.

When I Re-analyse, the new records are added to the list, and I need the checkboxes to be copied to the newest results. All goes well so far...
Then I need to remove the older results from the report, and run a query that unchecks the checkboxes on the older records. At the end of this routine I requery, to update the form and I get the same erroromessage as Philelpko...

I tried in-code SQL vs Access-Queries for it was documented somewhere on the internet as a problem between access and sql regarding interpretation of booleans (-1 vs 1), no result.

Any more suggestions without changing the checkboxes???