473,320 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access Help

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
6 2610
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
Nope

Nov 13 '05 #3
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
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
yeah it does thanks
thats more what i wass looking for

Nov 13 '05 #6
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: A.P. Madura | last post by:
Need help in debugging this problem. I have an access database which I use to demonstrate Java - ODBC connectivity and it works perfectly fine. This allows me to assume that the Data Source name...
1
by: mbeddedsoft | last post by:
I'm trying to use access as the database for a website. I don't expect too much traffic initially and I didn't want to bother with a more robust/complex db. Anyway, I have this 2 tables: Cart{...
0
by: MaryO | last post by:
I have tried to bring up the data access page after creating my tables and forms. The only problem is that the information is not linking right. My dropdown boxes have nothing in them and one of...
0
by: GMAVT | last post by:
I own a small business and we have a database on access. I need a small amount of work done and would like to find an Access Guru to do help out (for pay). If interested please email me at...
3
by: news.giganews.com | last post by:
Does anyone know if there's an easy way to export or copy the relationship structure from one mdb to a new one? The relationships in the db are time consuming to reproduce. I am trying to make a...
1
by: Dave Martin | last post by:
I am working on a project that is giving me trouble. It has to be done quickly. It is being written in C# and I am totally new to C#. I need to update an MS Access database application that...
0
by: roshnair | last post by:
Hi all Currently I am working in Access VBA Project(access 2003).Everything is working fine for my project and i just implemented it in client place . But in their office some mechine is in 2000...
2
by: Don I | last post by:
Microsoft Visual Basic .NET 55501-640-5372443-18381 I'm trying to access the program's help files but all I get is "Page can not be displayed". Any idea what's up? Thx. Don I
4
by: DyingIsis | last post by:
Hello - I'm a relatively new user of Access. None the less, I have a function within Excel that I would like to recreate in Access. The function called (Check if part of a cell matches...
2
risk32
by: risk32 | last post by:
OK. So I have NO idea what I'm doing. I've only worked with Excel VBA, JS, and HTML. No clue how to use access since it's different (except maybe the VB portion of Excel VBA). I'm trying to make a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.