On May 28, 3:16*pm, Tom van Stiphout wrote:
On Thu, 27 May 2010 18:45:35 -0700 (PDT), Lord Kelvan

wrote:

Actually that should be:
[ID]=[Forms]![ frmSwitchboard]![subfrmswitchboard].Form![ID]

The way I think about this syntax is that [Forms]![
frmSwitchboard]![subfrmswitchboard] accesses the subform control, so
you could inspect its properties (e.g. Left, SourceObject, etc).
.Form makes you step into the (sub)form and now you can access the
controls in that form.

-Tom.
Microsoft Access MVP



You need to reference the subform through the mainform because the
subform is not "open" as per say in the [forms] collection

Use the condition

[ID]=[Forms]![ frmSwitchboard]![subfrmswitchboard]![ID]

If you open this subform as a normal form as well then tell me and you
need to do something more complicated as this condition will not work
in that case.

Regards
Kelvan

Hi and thanks very much for the prompt responses.

Unfortunately I have tried both and the input box still appears (

Any other ideas and contributions will be greatly appreciated.

Many thanks again.