Access Help

[wedgea]

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

[MacDermott]

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

[Wedge]

Nope

[Tim Marshall]

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

[Holtz]

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

[Wedge]

yeah it does thanks
thats more what i wass looking for

[Larry Linson]

"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