query criteria is unbound control on tab control

K

ktdid

Hello - is there a way to reference a field on a tab on a tab control in a
parameter query? for example I have a tab control on a form called Main Menu
with three tabs and on the third tab I've added an unbound date field. I
thought I'd use Forms!Main Menu!tab name!Date but that isn't working. Is
this possible and, if so, what am I missing? Thank you!
 
P

Piet Linden

Hello - is there a way to reference a field on a tab on a tab control in a
parameter query?  for example I have a tab control on a form called Main Menu
with three tabs and on the third tab I've added an unbound date field.  I
thought I'd use Forms!Main Menu!tab name!Date but that isn't working.  Is
this possible and, if so, what am I missing?  Thank you!

link: http://www.mvps.org/access/forms/frm0025.htm

Refer to Controls on a tabbed form
Author(s)
Keri Hardwick

(Q) How do I refer to a control found on a tab page when I'm using
a tabbed form?

(A) The tab control has no impact on the syntax for referring to a
control. To refer to a control on the main form, you simply use
[Control name].

To refer to a property of a subform on a tab page, you use:

[Subform Control Name].Form.Property

To refer to a control on a subform on a tab page:

[Subform Control Name].Form![Control Name]

And, to refer to a property of a control on a subform on a tab page:

[Subform Control Name].Form![Control Name].Property
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top