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

Access Help

P: n/a
Im trying to build a database for my DBMS class. I need the code for a
form that makes it so when a user clicks a combo box and selects a
number from it it fills in the rest of the form based on the number
chosen. The fields i need to fill in are address city state zip. This
is for a grocery warehouse and the numbers in the combo box are the
store numbers. thanks for the help.

Wedge

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Are you asking us to do your homework for you?

<we****@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Im trying to build a database for my DBMS class. I need the code for a
form that makes it so when a user clicks a combo box and selects a
number from it it fills in the rest of the form based on the number
chosen. The fields i need to fill in are address city state zip. This
is for a grocery warehouse and the numbers in the combo box are the
store numbers. thanks for the help.

Wedge

Nov 13 '05 #2

P: n/a
Nope

Nov 13 '05 #3

P: n/a
MacDermott wrote:
Are you asking us to do your homework for you?


Sounds like it... "I need the code for..." Christ, why bother paying
the bucks for a class if one is going to be as lazy as this *appears* to
be...

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #4

P: n/a
Wedge

I'll give you the steps. Not the code. I don't do homework.
In the after update even of the combo box (hopefully the bound column
of your combo box points to a key on the table that is unique) select
the records from the table where they are equal to the value of the
combo box.
With the recordset selected set your text boxes, listbox's, etc values
equal to that of the recordset.

Hope it helps

Nov 13 '05 #5

P: n/a
yeah it does thanks
thats more what i wass looking for

Nov 13 '05 #6

P: n/a
"Wedge" <we****@gmail.com> wrote
yeah it does thanks
thats more what i wass looking for


Just for grins, that is one of the options for creating a Combo Box if you
have the Controls Wizard set (the "magic wand" in the toolbox). And the
Controls Wizard does not have any reticence about helping with your
homework. <GRIN>

That functionality used to be called "Query by Form" and was in help in
earlier versions of Access.

In fact, using the Wizard might be exactly what your instructor wants you to
do.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.