By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Subvalues -- like submenus? How can I do it?

P: n/a
One of those seemingly basic questions that I can't find the answer to:
I have a field "Action" with three lookup values: "Do_It",
"Delegate_It", and "Defer_It." When the user chooses "Do_It," I want
him to be able to choose from a second list of lookup values.

The simplest thing to do, I think, would be to have two separate
fields: Action (essentially, for "Delegate_It" and "Defer_It") and
Do_It (to be used only when the Action value is "Do_It." But I'm sure
there must be a more elegant way.

Jan 2 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Build a popup form named PFrmDoIt and add a combobox named DoItItem that
gives you a list of the Do_It options. You don't say exactly what you want
to do with the selected Do_It option so I'm going to assume you want to save
it to a field named DoItItem in a field on your Action form. I'm also
assuming you are selecting Action in a combobox. Put the following code in
the AfterUpdate event of your Action combobox:
If Me!Action = "Do_It" Then
DoCmd.Open Form "PFrmDoIt",,,,,acDialog
Me!DoItItem = Forms!PFrmDoIt!DoItItem
DoCmd.Close acForm, "PFrmDoIt"
End If

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1075 users have come from the newsgroups requesting help.
re******@pcdatasheet.com

"mgarelick" <mg*******@capsf.org> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
One of those seemingly basic questions that I can't find the answer to:
I have a field "Action" with three lookup values: "Do_It",
"Delegate_It", and "Defer_It." When the user chooses "Do_It," I want
him to be able to choose from a second list of lookup values.

The simplest thing to do, I think, would be to have two separate
fields: Action (essentially, for "Delegate_It" and "Defer_It") and
Do_It (to be used only when the Action value is "Do_It." But I'm sure
there must be a more elegant way.

Jan 2 '06 #2

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:dV*****************@newsread3.news.atl.earthl ink.net...
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1075 users have come from the newsgroups requesting help.
re******@pcdatasheet.com


Well I guess you have made some really nice plans for this New Year Steve?
To the OP:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R
Jan 3 '06 #3

P: n/a
"mgarelick" <mg*******@capsf.org> wrote
. . .
I have a field "Action" with three lookup values: "Do_It",
"Delegate_It", and "Defer_It." When the user chooses "Do_It," I want
him to be able to choose from a second list of lookup values.

The simplest thing to do, I think, would be to have two separate
fields: Action (essentially, for "Delegate_It" and "Defer_It") and
Do_It (to be used only when the Action value is "Do_It." But I'm sure
there must be a more elegant way.


"Elegance", like beauty, tends to be in the eye of the beholder. For me,
"simple", "straightforward", and "it works" is sufficiently elegant. Which
is how I woudl describe your two separate Fields solution.

However, if you mean a "Lookup Field", that is not "elegant", it is
"abominable" -- banish it from your database before it "rises up to bite you
in the tender places".

By all means, include a value with the three options, and another for the
suboptions... on the Form, implement those with Combo Boxes, and make the
second Visible in the AfterUpdate event of the first, if "Do It" was chosen.

You could jump through some hoops to make it different, but only the user
could decide if those different ways were more or less "elegant".

Larry Linson
Microsoft Access MVP

Jan 3 '06 #4

P: n/a
Bri
Arno,

Not that I am defending Steve, but it does look like he has modified his
signiture and no longer has the most offending line about his
'reasonable fees'. Perhaps this current signiture is a compromise that
both of you can live with and call an end to this war?

--
Bri

Jan 3 '06 #5

P: n/a
Steve has been quiet for the past few weeks and this is his second post.
Unfortunately, his other post (to one of the Microsoft newsgroups) was a
classic solicitation.

Arno's problem with steve's post may be the "Over 1075 users have come from
the newsgroups requesting help." in the sig line. He is still implying that
users can only get help if they contact him and he does not indicate how
many were expecting free help. If he did get 1,075 paying customers, why
does steve still need to troll the Access newsgroups for work shouldn't the
repeat business keep him busy?

John... Visio MVP

"Bri" <no*@here.com> wrote in message news:Dhzuf.127764$2k.58997@pd7tw1no...
Not that I am defending Steve, but it does look like he has modified his
signiture and no longer has the most offending line about his 'reasonable
fees'. Perhaps this current signiture is a compromise that both of you can
live with and call an end to this war?

Bri

Jan 3 '06 #6

P: n/a
Bri
I agree that that line in now the most offending line in his sig, but
the key to my message was 'compromise'. I doubt that you will ever
convince Steve to use a sig that everyone will not have a problem with.
The fact that he has modified the sig indicates that he is willing to
compromise. I'm asking if your side is also willing to call a truce and
let the groups (CDMA at least) get back to Access issues.

--
Bri

John Marshall, MVP wrote:
Steve has been quiet for the past few weeks and this is his second post.
Unfortunately, his other post (to one of the Microsoft newsgroups) was a
classic solicitation.

Arno's problem with steve's post may be the "Over 1075 users have come from
the newsgroups requesting help." in the sig line. He is still implying that
users can only get help if they contact him and he does not indicate how
many were expecting free help. If he did get 1,075 paying customers, why
does steve still need to troll the Access newsgroups for work shouldn't the
repeat business keep him busy?

John... Visio MVP

"Bri" <no*@here.com> wrote in message news:Dhzuf.127764$2k.58997@pd7tw1no...
Not that I am defending Steve, but it does look like he has modified his
signiture and no longer has the most offending line about his 'reasonable
fees'. Perhaps this current signiture is a compromise that both of you can
live with and call an end to this war?

Bri


Jan 3 '06 #7

P: n/a
I was only replying to your post with some background explanations, I was
not directly commenting on steve's behaviour.
Though I am not impressed with steve's sig line, I am not going to go after
him for that, especially in a non Mcrosoft newsgroup. I'll leave that to
others, like Arno, to comment on it. So there is no "your side". It is up to
Arno to decide, on his own, if steve's action is a compromise. For me, the
solicitation on New Year's Eve indicates that steve still does not have
respect for this community.

Again, I have no plans to comment on steve's new sigline, but if he does
post erroneous information or tells user that they need to contact him, I
will comment.

John... Visio MVP

"Bri" <no*@here.com> wrote in message news:PBBuf.14244$tl.6175@pd7tw3no...
I agree that that line in now the most offending line in his sig, but the
key to my message was 'compromise'. I doubt that you will ever convince
Steve to use a sig that everyone will not have a problem with. The fact
that he has modified the sig indicates that he is willing to compromise.
I'm asking if your side is also willing to call a truce and let the groups
(CDMA at least) get back to Access issues.

Bri

John Marshall, MVP wrote:
Steve has been quiet for the past few weeks and this is his second post.
Unfortunately, his other post (to one of the Microsoft newsgroups) was a
classic solicitation.

Arno's problem with steve's post may be the "Over 1075 users have come
from the newsgroups requesting help." in the sig line. He is still
implying that users can only get help if they contact him and he does not
indicate how many were expecting free help. If he did get 1,075 paying
customers, why does steve still need to troll the Access newsgroups for
work shouldn't the repeat business keep him busy?

John... Visio MVP

"Bri" <no*@here.com> wrote in message
news:Dhzuf.127764$2k.58997@pd7tw1no...
Not that I am defending Steve, but it does look like he has modified his
signiture and no longer has the most offending line about his 'reasonable
fees'. Perhaps this current signiture is a compromise that both of you
can live with and call an end to this war?

Bri

Jan 3 '06 #8

P: n/a
Mal
With a list as short as you gave...
and...
If the secondary list will be equally as small...ie, 3 - 5 items...
then I would consider making the first list include the other options.
eg.
Do it...Now
Do it...Later
Do it...when enough complaints come in
Delegate it
Defer it.

HTH
Mal.
"mgarelick" <mg*******@capsf.org> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
One of those seemingly basic questions that I can't find the answer to:
I have a field "Action" with three lookup values: "Do_It",
"Delegate_It", and "Defer_It." When the user chooses "Do_It," I want
him to be able to choose from a second list of lookup values.

The simplest thing to do, I think, would be to have two separate
fields: Action (essentially, for "Delegate_It" and "Defer_It") and
Do_It (to be used only when the Action value is "Do_It." But I'm sure
there must be a more elegant way.

Jan 4 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.