J
Jim T
have a home inventory form which has a linked object (photo) of the item.
The photo of the items are dynamically linked based on the (auto) item
number via
setting the picture property of the object on the form. The form also has a
number of subforms and search fields using queries containing IIF criteria
based on the values on the form (e.g.
iif(isnull([forms]![inventory]![item_number],[item_number],
([forms]![inventory]![item_number]).
The issue an "import ..." message is issued every time the form is
referenced. A message (or messages) are even issued when I enter desgin mode
of one of the queries containing the form reference. Once the form is opened,
the link to a new picture for the selected item occurs only once and is
acceptable in terms of refresh.
The problem is on opening the form since there are quite a few references to
the form the "import" message appears appears a large number of times and
consequently the response time for opening the form is lengthy.
Any options?
Thanks
Jim T.
The photo of the items are dynamically linked based on the (auto) item
number via
setting the picture property of the object on the form. The form also has a
number of subforms and search fields using queries containing IIF criteria
based on the values on the form (e.g.
iif(isnull([forms]![inventory]![item_number],[item_number],
([forms]![inventory]![item_number]).
The issue an "import ..." message is issued every time the form is
referenced. A message (or messages) are even issued when I enter desgin mode
of one of the queries containing the form reference. Once the form is opened,
the link to a new picture for the selected item occurs only once and is
acceptable in terms of refresh.
The problem is on opening the form since there are quite a few references to
the form the "import" message appears appears a large number of times and
consequently the response time for opening the form is lengthy.
Any options?
Thanks
Jim T.