Crosstab Nightmare

  • Thread starter Thread starter Rod Makin
  • Start date Start date
R

Rod Makin

HEEEELLLLLLLPPPPPP!!

I can't get a form to refresh, not no how, not noway!! Going from Design
view to Form View keeps the data the same refresh doesn't work. requery
doesn't work. Is this a limitation of Access? Here is a really quick example
of the problem:-
Table looks like

Burt Apples Yes
Burt Pears No
Ernie Apples Yes
Ernie Pears Yes

In a crosstab query this looks like

Apples Pears
Burt Yes No
Ernie Yes Yes

I have this crosstab in a form, but even when I change the data in the table
the data does not change when I requery the form, or refresh or repaint or
anything, even when I go from design form to show form it doesn't refresh
the data. What can I do? C'mon you geniuses there is a simple table, a
simple crosstab, and a simple form it would only take a few minutes to see
if I'm going MADDDD!!!

Thanks in advance


Rod
 
Weirder and weirder, on the example below, the refresh does not work from
the menu, BUT if I sort the data it is refreshed. I think that I have my
solution, but why is this happening and is there a better way of doing this?

Cheers



Rod
 
Back
Top