Is it possible to reference a particular Tab in a particular Form in the "Where Clause" when opening a Form with a Click event?
Is it possible to reference a particular Tab in a particular Form in the "Where Clause" when opening a Form with a Click event?
Tabbed forms is a specific thing, as are tab controls (which have pages) as are navigation form tabs. All 3 mean something different. Which one are we talking about?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I didn't realize that. I created a form that contains tabs which each have Command buttons for opening other forms.
Sounds like TAB CONTROL on a normal form. Unless it is a NAVIGATION FORM with embedded form that has buttons.
Which is it?
And No, referencing TAB in the context you describe makes no sense.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I would say TAB CONTROL on a normal form. Never heard of NAVIGATION FORM. I'm still wet behind the ears... I know it sounds odd I just was wondering if it was doable.
Why would you even think it is needed?
NAVIGATION FORM is an option on the Create design tab.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I think you're saying you have a form with a tab control and it has pages (aka "tabs" but select a "tab" in design view and see what the selection type is on the property sheet - it is "Page"). Anyway, AFAIK, as long as this isn't a subform the same reference syntax applies as what's used for any other form control:
Forms!NameOfYourForm.NameOfYourControl
Referenced form has to be open of course, and not in design view. A tab control, its pages and controls on the pages are all children of the main form, as weird as that seems. In form code you can simply msgbox Me.nameOfControl where that control is on a page of a tab control on that form. Should be same behaviour from the query side I suspect.
Can't imagine why you want to reference the "tab" in a query anyway. Would have thought it should be referencing a control/field.
Last edited by Micron; 05-28-2019 at 01:51 PM. Reason: spelin and gramur