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

List box recordset, Form recordset

P: n/a
JC
Hey Folks,

I am having a problem and I need some expert help. I am trying to
populate a list box with a record set based off of a table field on the
open procedure. I then want to have that list box adjust to what my
user inputs into the box. Example... user enters last name and the
list box scrolls through available values.

Once that is complete I want the user to click that value in the list
box and then have the form populate from that list box.

I know there is some code out there that I can use for this. I used it
when I worked with Access 2000 about 4 years ago. I am back to working
with this again. I just cannot find it.

Thanks you for your help,

Justin

Oct 13 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
It sounds like you want a lookup listbox. One thing you can try is to
create a form that is based on the table/query that contains the
information you want to display then use the tools wizard to create the
listbox. To use the tools wizard, on the toolbar at the top end of it
you will see a pointer icon and a magic wand icon. select the magic
wand, then select the listbox and drag/draw it on the form. A wizard
dialog will appear. Follow the instructions on the wizard.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 13 '06 #2

P: n/a
It sounds like you want a lookup listbox. One thing you can try is to
create a form that is based on the table/query that contains the
information you want to display then use the tools wizard to create the
listbox. To use the tools wizard, on the toolbar at the top end of it
you will see a pointer icon and a magic wand icon. select the magic
wand, then select the listbox and drag/draw it on the form. A wizard
dialog will appear. Follow the instructions on the wizard.
Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 13 '06 #3

P: n/a
JC
Thanks Rich for the help.
However,
I would like to do this in code since I know it can be done. I just
need to get an example to work from. I will continue to look.

Thank you.
Rich P wrote:
It sounds like you want a lookup listbox. One thing you can try is to
create a form that is based on the table/query that contains the
information you want to display then use the tools wizard to create the
listbox. To use the tools wizard, on the toolbar at the top end of it
you will see a pointer icon and a magic wand icon. select the magic
wand, then select the listbox and drag/draw it on the form. A wizard
dialog will appear. Follow the instructions on the wizard.
Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 13 '06 #4

P: n/a
"JC" <ag******@yahoo.comwrote in
news:11**********************@b28g2000cwb.googlegr oups.com:
Thanks Rich for the help.
However,
I would like to do this in code since I know it can be done.
I just need to get an example to work from. I will continue
to look.

Thank you.
do the wizard thing, it will create the code..
>

Rich P wrote:
>It sounds like you want a lookup listbox. One thing you can
try is to create a form that is based on the table/query that
contains the information you want to display then use the
tools wizard to create the listbox. To use the tools wizard,
on the toolbar at the top end of it you will see a pointer
icon and a magic wand icon. select the magic wand, then
select the listbox and drag/draw it on the form. A wizard
dialog will appear. Follow the instructions on the wizard.
Rich

*** Sent via Developersdex http://www.developersdex.com ***



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Oct 13 '06 #5

P: n/a
JC
Rich, Bob-

I finally gave up on the code thing and completed it using the
wizard...WOW..much easier.

You guys know if I can look at the code that was created in the
background?

Thank you!!!

Justin

Bob Quintal wrote:
"JC" <ag******@yahoo.comwrote in
news:11**********************@b28g2000cwb.googlegr oups.com:
Thanks Rich for the help.
However,
I would like to do this in code since I know it can be done.
I just need to get an example to work from. I will continue
to look.

Thank you.

do the wizard thing, it will create the code..


Rich P wrote:
It sounds like you want a lookup listbox. One thing you can
try is to create a form that is based on the table/query that
contains the information you want to display then use the
tools wizard to create the listbox. To use the tools wizard,
on the toolbar at the top end of it you will see a pointer
icon and a magic wand icon. select the magic wand, then
select the listbox and drag/draw it on the form. A wizard
dialog will appear. Follow the instructions on the wizard.
Rich

*** Sent via Developersdex http://www.developersdex.com ***

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
Oct 16 '06 #6

P: n/a

"JC" <ag******@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
Rich, Bob-

I finally gave up on the code thing and completed it using the
wizard...WOW..much easier.

You guys know if I can look at the code that was created in the
background?
Look at the Control in Design View, open its Property Sheet, click the
Events tab, then look to see which events have something in the space to the
right, click in that space, then click the small control with three dots
that appears at the far right. That is where the code created by the Wizard
will be found -- it is not a bad way to get started understanding VBA.

Larry Linson
Microsoft Access MVP
Oct 16 '06 #7

P: n/a
JC
Thanks Larry for the help. Got it...

JC
Larry Linson wrote:
"JC" <ag******@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
Rich, Bob-

I finally gave up on the code thing and completed it using the
wizard...WOW..much easier.

You guys know if I can look at the code that was created in the
background?

Look at the Control in Design View, open its Property Sheet, click the
Events tab, then look to see which events have something in the space to the
right, click in that space, then click the small control with three dots
that appears at the far right. That is where the code created by the Wizard
will be found -- it is not a bad way to get started understanding VBA.

Larry Linson
Microsoft Access MVP
Oct 20 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.