Strange problem.

[pompeyjim]

I have a rather strange problem. I have designed a DB in Access 2000, on a
computer running Windows 2000. The DB has been installed onto a computer
running Access 2003 with XP as the OS. It has a main form with a subform. The
main form is where invoice data is input and the subform is where the
products sold for each invoice are input. When the form loads in Access 2003
and the subform has data in it, the Status bar shows Calculating. No data can
be input, nothing can receive the focus and you cannot navigate to the next
record until the mouse is moved over the subform. On my own computer, where
the DB was designed, this does not happen. Also, it does not happen in Access
2003 if there is no data in the subform. Any ideas anyone?

 

[Allen Browne]

To pin down the culprit, try temporarily removing things until it does work.

Examples
- Any conditional formatting.
- Any code in the form's Current event.
- Any calculated fields.
- Other code.

If that doesn't solve it, make sure that Name AutoCorrect is turned off
under:
Tools | Options | General
For why, see:
http://allenbrowne.com/bug-03.html

Then compact the database:
Tools | Database Utilities | Compact

Still stuck?
- Make sure the tables' SubdatasheetName property is No.
- What is in the LinkMasterFields/LinkChildFields properties of the subform
control?
- Probably won't affect this issue, but in A2002 and 2003 you also need to
make sure the subform has a text box for the foreign key field (the one(s)
names in LinkChildFields.)

 

[pompeyjim]

Thanks very much for your advice Allen. I have noticed that the Name
AutoCorrect was turned on so I have turned it off. I can't try it until
Monday morning but I'll let you know how I get on, in this post.

 

[pompeyjim]

I turned off the conditional formatting and that seemed to do the trick.
Thanks for your advice Allen.