Get control location

[ykhamitkar]

Hi there,

I have ms access form and within that many other sub forms which hold date fields. I want to use singe calendar control for these date fields.

How can get location of a control (e.g. Form_main!frm_s ubform!controln ame) when user double clicks on particular date text box

with Screen.ActiveCo ntrol.Name I can get name but I need entire path for the control.


Thanks,
Yogesh

[MMcCarthy]

Yogesh

Can you explain better what you are trying to do?