It is not set by VBA code...the control source for the "description" field is
just "SKU Desc" which is a field in the source query.

"Dirk Goldgar" wrote:

"DJM2290" wrote in message
...
How do I get a control to update in a form without closing the form and
re-opening it? It used to work fine before I converted the DB to 2007.
Basically, a user keys in an item number, and I would like the item
description control to populate after they move out of the item control
field. The source for the form is a select query. Any help would be
appreciated.


The only thing that has change in this regard between Access 2003 (or
earlier) and Access 2007 is that VBA code doesn't run in Access 2007 unless
you explicitly enable it or put the database in a trusted location (as
established in the Trust Center settings).

Could that be the problem? Is the description being set by VBA code?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

.