Form level variables - the way to do this?

[Mike MacSween]

It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
subforms.

(I like tabbed forms by the way - do we all?)

Basically the subforms are different ways of looking at the data. It's the
orchestral management thing still.

So tab 1 looks at each musician, the events they're booked onto, which jobs
they're doing etc.

tab 2 looks at each job, who's doing it at which event etc.

To preserve state between tabs I've set up a few form level variables, so
that when you're on musician A on one subform when you switch to another tab
you'll be on musician A there too. Hopefully.

Is form level variables the usual way to accomplish this? If there is a
'usual' way.

TIA, Mike MacSween

[Mike Storr]

Re: Form level variables - the way to do this?

Unless you are doing something to change the state of the tabs, they should
retain whatever state they were left in.
(Unless one is in the middle of a record edit, in wich case it will attempt
to update it when it looses focus)

Mike Storr

https://www.veraccess.com

"Mike MacSween" <mike.macsween. damnthespam@bti nternet.com> wrote in message
news:40483509$0 $63624$5a6aecb4 @news.aaisp.net .uk...[color=blue]
> It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
> subforms.
>
> (I like tabbed forms by the way - do we all?)
>
> Basically the subforms are different ways of looking at the data. It's the
> orchestral management thing still.
>
> So tab 1 looks at each musician, the events they're booked onto, which[/color]
jobs[color=blue]
> they're doing etc.
>
> tab 2 looks at each job, who's doing it at which event etc.
>
> To preserve state between tabs I've set up a few form level variables, so
> that when you're on musician A on one subform when you switch to another[/color]
tab[color=blue]
> you'll be on musician A there too. Hopefully.
>
> Is form level variables the usual way to accomplish this? If there is a
> 'usual' way.
>
> TIA, Mike MacSween
>
>[/color]

[Tom van Stiphout]

Re: Form level variables - the way to do this?

On Fri, 5 Mar 2004 08:06:38 -0000, "Mike MacSween"
<mike.macsween. damnthespam@bti nternet.com> wrote:

I see nothing wrong with it. However, you could also reference the
master musician list itself, eliminating the need for a variable:
"select * from events where MusicianID=" &
subfrmMusicians .Form.MusicianI D

-Tom.


[color=blue]
>It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
>subforms.
>
>(I like tabbed forms by the way - do we all?)
>
>Basically the subforms are different ways of looking at the data. It's the
>orchestral management thing still.
>
>So tab 1 looks at each musician, the events they're booked onto, which jobs
>they're doing etc.
>
>tab 2 looks at each job, who's doing it at which event etc.
>
>To preserve state between tabs I've set up a few form level variables, so
>that when you're on musician A on one subform when you switch to another tab
>you'll be on musician A there too. Hopefully.
>
>Is form level variables the usual way to accomplish this? If there is a
>'usual' way.
>
>TIA, Mike MacSween
>[/color]

[David W. Fenton]

Re: Form level variables - the way to do this?

"Mike MacSween" <mike.macsween. damnthespam@bti nternet.com> wrote in
news:40483509$0 $63624$5a6aecb4 @news.aaisp.net .uk:
[color=blue]
> It's a form, with (so far) 4 tab pages on it, each of which holds
> 2/3/4 subforms.
>
> (I like tabbed forms by the way - do we all?)[/color]

Yes, I'm a tabbed form addict. My users taught me to be, as they
hate popup forms, in general, because it's too easy to get lost.

(a fascinating article on UI design errors:

http://www.catb.org/~esr/writings/cups-horror.html

I recommend that everyone read this and the followup referred to at
the end; it's not about tabbed interfaces, but it makes a number of
points that are pretty important)
[color=blue]
> Basically the subforms are different ways of looking at the data.
> It's the orchestral management thing still.
>
> So tab 1 looks at each musician, the events they're booked onto,
> which jobs they're doing etc.
>
> tab 2 looks at each job, who's doing it at which event etc.
>
> To preserve state between tabs I've set up a few form level
> variables, so that when you're on musician A on one subform when
> you switch to another tab you'll be on musician A there too.
> Hopefully.
>
> Is form level variables the usual way to accomplish this? If there
> is a 'usual' way.[/color]

Well, shouldn't this be data-driven?

The usual design of a parent form/subform is that the subforms are
linked to the record displayed in the parent form. That would be a
very easy way to coordinate multiple subforms.

If, on the other hand, your parent form is unbound and displays a
number of subforms that are not all children of the same parent, you
could create a control that does display the common information and
use that for your link.

That is, if you're moving between two tabs that both display
information about the same person, there ought to be a header in
common to those two tabs that displays which person the child data
is about, and also allows you to navigate to a different person.

One way to accomplish this would be to have the "header" portion of
the form be a tab control with no tabs displayed. You'd have
sufficient tabs on it to display as many different headers as you
needed, with navigation for those headers, and the tab shown on the
header would be driven in the OnChange event of the tab.

I can see possible problems with that with certain kinds of design,
but you get the idea, maybe. The principle is that there should be a
header that is shared between tabs that display the same kind of
information.

And if you need different headers, you might consider breaking the
whole thing down into separate forms. While I avoid popups so users
don't have to navigate between different forms all the time, I do
think you need to keep distinct entities separated from each other.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Steve Jorgensen]

Re: Form level variables - the way to do this?

On Fri, 05 Mar 2004 15:25:26 GMT, "David W. Fenton"
<dXXXfenton@bwa y.net.invalid> wrote:
[color=blue]
>"Mike MacSween" <mike.macsween. damnthespam@bti nternet.com> wrote in
>news:40483509$ 0$63624$5a6aecb 4@news.aaisp.ne t.uk:
>[color=green]
>> It's a form, with (so far) 4 tab pages on it, each of which holds
>> 2/3/4 subforms.
>>
>> (I like tabbed forms by the way - do we all?)[/color]
>
>Yes, I'm a tabbed form addict. My users taught me to be, as they
>hate popup forms, in general, because it's too easy to get lost.
>
>(a fascinating article on UI design errors:
>
>http://www.catb.org/~esr/writings/cups-horror.html[/color]

Neat article - thanks for the link.