VALUE SAVED BY COMBO BOX

[RICHARD BROMBERG]

Using MS Access 2000 and the combo box wizard.

I am a little light in using Code but not bad creating forms, tables,
queries in Design View or using a Wizard.

I am using a combo box to look up the values in a table.


How do I access the value if I select "remember the value for later use" ?

I'd like to use it to set the criteria in a query but can't figure out how
to reference it ,

Thanks

Semi Duffer

[Wayne Morgan]

Re: VALUE SAVED BY COMBO BOX

I usually don't use the wizard, but I believe that the "remember the value
for later use" binds the combo box to a field in the form's Record Source.
To refer to the value of the combo box from a query the form must be open
and use syntax similar to this:

Forms!frmMyForm !cboMyCombobox

--
Wayne Morgan
MS Access MVP


"RICHARD BROMBERG" <dickbrom@world net.att.net> wrote in message
news:rVQSb.3992 1$6O4.1139281@b gtnsc04-news.ops.worldn et.att.net...[color=blue]
> Using MS Access 2000 and the combo box wizard.
>
> I am a little light in using Code but not bad creating forms, tables,
> queries in Design View or using a Wizard.
>
> I am using a combo box to look up the values in a table.
>
>
> How do I access the value if I select "remember the value for later use"[/color]
?[color=blue]
>
> I'd like to use it to set the criteria in a query but can't figure out how
> to reference it ,
>
> Thanks
>
> Semi Duffer
>
>
>
>
>
>
>[/color]

[Tom van Stiphout]

Re: VALUE SAVED BY COMBO BOX

On Sat, 31 Jan 2004 16:41:59 GMT, "RICHARD BROMBERG"
<dickbrom@world net.att.net> wrote:

In your query, set the criteria to:
Forms!MyForm!My Combobox

-Tom.

[color=blue]
>Using MS Access 2000 and the combo box wizard.
>
>I am a little light in using Code but not bad creating forms, tables,
>queries in Design View or using a Wizard.
>
>I am using a combo box to look up the values in a table.
>
>
> How do I access the value if I select "remember the value for later use" ?
>
>I'd like to use it to set the criteria in a query but can't figure out how
>to reference it ,
>
>Thanks
>
>Semi Duffer
>
>
>
>
>
>[/color]

[Bas Cost Budde]

Re: VALUE SAVED BY COMBO BOX

No, the setting "remember the value" is an euphemism for "do not store
the value" (create unbound control). Since the control lives on the
form, the value *will* be available as long as the form stays open.
Tom's and uour syntax will do.

Wayne Morgan wrote:[color=blue]
> I usually don't use the wizard, but I believe that the "remember the value
> for later use" binds the combo box to a field in the form's Record Source.
> To refer to the value of the combo box from a query the form must be open
> and use syntax similar to this:
>
> Forms!frmMyForm !cboMyCombobox
>[/color]

--
Bas Cost Budde

[Tony Toews]

Re: VALUE SAVED BY COMBO BOX


"Bas Cost Budde" <bas@heuveltop. org> wrote in message
news:bvi59v$9q0 $1@news2.solcon .nl...
[color=blue]
>Comments: This message did not originate from the Sender address above.
> It was remailed automatically by anonymizing remailer software.[/color]

Please ignore this posting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

[Wayne Morgan]

Re: VALUE SAVED BY COMBO BOX

Actually, the one from "Tony" is the fake. Header below. Note the
teranews.com address.

X-Abuse-Report: abuse@teranews. com
Message-ID: <a5d6cab06258b7 258c731e7b12d07 932@news.terane ws.com>
Path:
newssvr33.news. prodigy.com!new sdbm02.news.pro digy.com!newsms t01.news.prodig y
..com!prodigy.c om!pd7cy2so!sha w.ca!border1.nn tp.ash.giganews .com!nntp.gigan ew
s.com!newsfeed-east.nntpserver .com!nntpserver .com!news.teran ews.com!not-for-
mail
Date: Mon, 02 Feb 2004 02:32:37 GMT
Lines: 18
From: "Tony Toews" <tonythephony@y ahoo.com>
Newsgroups: comp.databases. ms-access
References: <rVQSb.39921$6O 4.1139281@bgtns c04-news.ops.worldn et.att.net>
<_3RSb.12101$LZ 7.10942@newssvr 22.news.prodigy .com>
<bvi59v$9q0$1@n ews2.solcon.nl>
Subject: Re: VALUE SAVED BY COMBO BOX
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Xref: newsmst01.news. prodigy.com comp.databases. ms-access:786767

--
Wayne Morgan
Microsoft Access MVP


"Tony Toews" <tonythephony@y ahoo.com> wrote in message
news:a5d6cab062 58b7258c731e7b1 2d07932@news.te ranews.com...[color=blue]
>
> "Bas Cost Budde" <bas@heuveltop. org> wrote in message
> news:bvi59v$9q0 $1@news2.solcon .nl...
>[color=green]
> >Comments: This message did not originate from the Sender address above.
> > It was remailed automatically by anonymizing remailer software.[/color]
>
> Please ignore this posting.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>
>[/color]

[Bas Cost Budde]

Re: VALUE SAVED BY COMBO BOX

Wayne Morgan wrote:
[color=blue]
> Actually, the one from "Tony" is the fake. Header below. Note the
> teranews.com address.[/color]

Of course, but I'm not troubled. I don't fear a sensible answer will be
'ignored'.

I see the value in pointing out forgeries and I'm not good at it so
thank you.
--
Bas Cost Budde