use VBA to close Linked Table Manager dialog box

[Rafi]

The problem is that combos within one of the forms stoped doing search for
existing data, but the data is visible within the combo list. When you type,
it just doesn't give you marked on screen alphabetically next close to it
line.
All the tables are linked correctly and all the forms and querries are
working fine.
I noticed that to fix this problem all I need is to open the Link Table
Manager dialog
box and then do cancel or ESC without changing nothing,- and everything
works fine
again. I spent almost a week trying to figure out the problem,- but I can't
find anything that would cause it. Then in order to release users from
touching the
data links,- I used the acCmdLinkedTableManager line to open the dialog box
of Linked TAble Manager on Swithchboard Form load. All I need now is to
close
it thru the next VBA line. I tried using Sendkeys "{ESC}",- but it doesn't
work.

Open for any ideas anyone might have....

 

[Jeanette Cunningham]

This sounds a bit like the SP3 bug for Acces 2003.
If you are using A2003 and have SP3, have a look at this:

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007
http://support.microsoft.com/kb/945674



Jeanette Cunningham