Form/Subform & XP

[Fionnbarr Kennedy]

Hi all
I have posted this problem before but am having no joy! I have an
app written in Access 2000 which is based around a Form/Subform. The
problem is with a new XP box only - the same app runs fine on all
others. The subform is displaying the #Error symbol: closing and re
opening it solves the problem. Compact/Repair doesn't work, creating
a new database and importing the objects doesn't work either. Re
creating the form worked very briefly: after adding and deleting some
15 records the problem re appeared.

As this same app works on all other computers (including another XP
machine with the same patches) I am completly stuck! Do I need to
re-install Access, XP, buy Access XP or give up?! Any ideas would be
MUCH appreciated - I am completly foxed!

Many thanks

Fionnbarr Kennedy

[Pavel Romashkin]

Does a requery of the form and subform help? F9? If so, put Requery in
the code.

Pavel

Fionnbarr Kennedy wrote:

Hi all
I have posted this problem before but am having no joy! I have an
app written in Access 2000 which is based around a Form/Subform. The
problem is with a new XP box only - the same app runs fine on all
others. The subform is displaying the #Error symbol: closing and re
opening it solves the problem. Compact/Repair doesn't work, creating
a new database and importing the objects doesn't work either. Re
creating the form worked very briefly: after adding and deleting some
15 records the problem re appeared.

As this same app works on all other computers (including another XP
machine with the same patches) I am completly stuck! Do I need to
re-install Access, XP, buy Access XP or give up?! Any ideas would be
MUCH appreciated - I am completly foxed!

Many thanks

Fionnbarr Kennedy

[Fionnbarr Kennedy]

Hi Pavel. Many thanks but no - Iv'e re queried till I'm blue in the
face with no joy. I'm beginning to think its an Access 2000 - XP
issue: anyone else found issues like this?

Fionnbarr

Pavel Romashkin <pa*************@hotmail.com> wrote in message news:<3F**************@hotmail.com>...

Does a requery of the form and subform help? F9? If so, put Requery in
the code.

Pavel