Not using Lookup Fields might also be an answer:

The Evils of Lookup Fields in Tables:
http://www.mvps.org/access/lookupfields.htm

It is as true in ac2007 as any previous version (IMO).

TraciAnn wrote:
A sub form (fsubCallDetail) for which the purpose is to DISPLAY detail
records only. The parent form, frmCall, shows the Contact information and
fsubCallDetail is to show an overview of call history. I tried playing with
the various properties but I can't find the one that turns off the display of
the drop down handle for lookup fields.

The same problem exists with the date fields, the calendar tag should not
appear on this sub form. These objects should show on the applicable add/edit
forms but the sub form is not for add/edit.

Thanks!


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200904/1